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!