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
 

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

Conditional formatting dates 3
Conditional Formatting Query 1
Excel Conditional Formatting Removal 7
conditional formatting update issue 5
conditional formatting? 1
Excel Conditioning Formatting 3
Conditional Formatting 3
Conditional formatting 3

Back
Top