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

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

Pete

On Nov 27, 12:57 pm, Sean wrote:
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

Hey, just did this based on an archived post

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