Conditional Format

M

McDuffie

How do I do a conditional format to check to see if any
cell in the range A2:A10 has the word "complete" type in.
If the word "Complete" is there then the condition is True
 
P

Paul

McDuffie said:
How do I do a conditional format to check to see if any
cell in the range A2:A10 has the word "complete" type in.
If the word "Complete" is there then the condition is True
Click to expand...

Try this:
=COUNTIF(A2:A10,"complete")>0
 

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

Changing row background from external program 0
Mail Merge Directory Conditional Page Break 0
Conditional Formatting 3
How can i put text in a cell depending on colour 0
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Conditional Formatting 6
Conditional Formatting Formula 3
Perplexed by simple Icon Set Cond. Formatting Issue 0

Top