CF problem

[howard]

I would like to set up CF for "No Shows" that appears in Col A

I have set up a formula

=ISNUMBER(SEARCH("No Shows",A2))=True

The Rage is $A:$F

It is highlighting all cells in green. It would be appreciated if someone can assist me

 

[James006]

Hi,

You could test following formula:

[COLOR=#333333]=ISNUMBER(SEARCH("No Shows",A2))[/COLOR]

Hope this will help

 

[MARK858]

Why not Just...

=A2="No Shows"

 

[Fluff]

Or if you want to highlight the entire row
=$A1="No Shows"

 

[howard]

Thanks for the help guys

 

[Fluff]

You're welcome