Using string in Conditional field formula
 

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!

Using string in Conditional field formula
 

=$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!

Using string in Conditional field formula
 

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.



Roger wrote:

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!

--

Dave Peterson

Using string in Conditional field formula
 

Formula is =$H2="Done"


--
Anything is possible if you don''t know what you''re talking about.


"Roger" wrote:

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!

Using string in Conditional field formula
 

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.

"David Biddulph" wrote:

=$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!