conditional formating

I

Ian@visualise

I want to format cells so that if they contain a letter i.e. "r" they will have a fill colour no matter what else is in the cell i.e rota in the cell turns it green os does run. any ideas anyone
ian c
 
J

JE McGimpsey

One way:

CF1: =FIND("r",A1)

Note: FIND() is case sensitive. If you wish the formatting to be case
insensitive, use SEARCH() instead
 

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

Excel does not accept text format! 0
Using colour conditional formatting to show whether due date has past 0
Conditional Formatting 2
Outlook 365 overriding formatting choices 0
To find Maximum value using conditional formatting 2
VBA - exporting serial letters to single documents 0
Is this possible? 1
Excel 2010 Conditional Formatting 2

Top