conditional formating

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
One way:

CF1: =FIND("r",A1)

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