Using string in Conditional field formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Help needed 0
conditional formula 1
Nesting SUMIF 11
conditional formatting 1
Conditional Formating with IF and AND formula 2
Conditional Formatting and Cell References 10
Conditional Formatting Applying Rule to Entire Column 2

Back
Top