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
 
Top