Conditional Formatting Q

S

Sean

How could I set a Conditional Format for a cell (to turn white text)
if the cells contents includes at least the following text location #

I have a number of possible wording within the cell and any contain
the above text I wish to change to white font. Not sure how to do this
with 'variable' text

Thanks
 
P

Pete_UK

I think you missed something from your post - can you give a few
examples of what you mean by "variable" text?

Pete
 
S

Sean

Hey, just did this based on an archived post

=FIND("Location #",A10) > 0, this is posted within CF in cell A10
 
Top