conditional formatting for cells containing words
 

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

conditional formatting for cells containing words
 

Click on "Formula Is", and enter this:

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

HTH,

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


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

conditional formatting for cells containing words
 

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


"LawW" wrote:

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