Conditional Formatting

[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

 

[Biff]

Hi Phil,

Yes you can. Try something like:

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

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

Biff