S skc Feb 26, 2009 #1 i have used two of the functions but ii need to have a color to hightlight all cells that have parking, p, prk
i have used two of the functions but ii need to have a color to hightlight all cells that have parking, p, prk
S Sheeloo Feb 26, 2009 #2 Do you want to higlight cells having these values or containing these in their values? To highlight Cell A1 (in the latter case) Choose Conditional Formatting Use FORMULA IS =OR(A1="parking',A1="prk",A1="p") and format as you want In the former case you really need to have value CONTAINING p
Do you want to higlight cells having these values or containing these in their values? To highlight Cell A1 (in the latter case) Choose Conditional Formatting Use FORMULA IS =OR(A1="parking',A1="prk",A1="p") and format as you want In the former case you really need to have value CONTAINING p
