Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting when inserting a row | Excel Worksheet Functions | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |