conditional format
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
"skc" wrote:
i have used two of the functions but ii need to have a color to hightlight
all cells that have parking, p, prk
|