Conditional Formatting Q

  • Thread starter Thread starter Sean
  • Start date Start date
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
 
I think you missed something from your post - can you give a few
examples of what you mean by "variable" text?

Pete
 
Hey, just did this based on an archived post

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

conditional formatting update issue 5
Conditional format cell containing hyperlink 2
Conditional Formatting 1
Conditional formating a cell containing a date 1
Comparison of columns using Conditional Formatting 3
Excel Conditional Formatting 1
Conditional formatting and IF 2
Excel Excel Conditional Format 2

Back
Top