Conditional Formatting

  • Thread starter Thread starter Phil
  • Start date Start date
P

Phil

Hey guys, does anyone know if you can use wildcards in
conditional formatting. I want a cell to change colour if
it includes the word "monthly" but it may also include
additional words or numbers e.g. "6 monthly".

Phil
 
Hi Phil,

Yes you can. Try something like:

=COUNTIF(A1,"*MONTHLY*")>0

This will format the entire cell, not just the word
monthly.

Biff
 
Back
Top