conditional formatting for cells containing words

L

LawW

conditional formatting works very well with numbers. Is there a way to
conditionally format a cell that contains words? For example if the cell
contains "confirmed" would be green and "decline" would be red - works. What
about if the cell conatins "confirmed" but also something else in that cell?
Thanks
 
R

RagDyeR

Click on "Formula Is", and enter this:

=ISNUMBER(SEARCH("defined",A1))
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


conditional formatting works very well with numbers. Is there a way to
conditionally format a cell that contains words? For example if the cell
contains "confirmed" would be green and "decline" would be red - works. What
about if the cell conatins "confirmed" but also something else in that cell?
Thanks
 
R

Ron Coderre

Try this:
For text in Cell A1

<Format><Conditional Formatting>
Condition 1:
Formula is: =ISNUMBER(SEARCH("confirmed",A1))
(Set the format for condition 1)

Condition 2:
Formula is: =ISNUMBER(SEARCH("decline",A1))
(Set the format for condition 2)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
Top