Using string in Conditional field formula

R

Roger

I am trying to apply a conditional formula to a range of cells. I want rows
to have a different color if the contents of the cell in column H has the
word Done in it. Is there a way to do this, or does the conditional formula
have to reference a numeric value? Using 'Formula is =$H2=Done' does
nothing. Thanks!
 
D

Dave Peterson

How about just using
Cell Value is:
equal to:
="done"

If you really meant that cell can contain Done and other text:

Formula is:
=countif(a1,"*done*")>0

With A1 the activecell.
 
R

Roger

Thanks, guys. Can't believe I didn't think of double-quotes. I'm so used to
using single quotes in sql statements. Make things too hard sometimes.
Thanks, again.
 
Top