conditional format

S

skc

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

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
 
Top