=$H2="Done"

You need quotes around any text string.
--
David Biddulph

"Roger" wrote in message
...
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!