View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
 
Posts: 1,805
Default 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