Conditional Format

  • Thread starter Thread starter McDuffie
  • Start date Start date
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
 
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
 
Back
Top