Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formating - wildcards
I have a database that has the following items
light snow snow sunny partly sunny cloudy some clouds I would like to use conditional formating to show one clour for light snow or snow and another colour for sunny or partly sunny and a third colour for cloudy or some clouds. Can I use wildcards for the 'conditional formatting'. How? thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formating - wildcards
In the CF Dialog, change "Cell Value Is" to "Formula Is" and use
a formula like =OR(A1="light snow",A1="snow") Do the same for the other conditions. Of course, change A1 to the cell in question. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Terry" wrote in message ... I have a database that has the following items light snow snow sunny partly sunny cloudy some clouds I would like to use conditional formating to show one clour for light snow or snow and another colour for sunny or partly sunny and a third colour for cloudy or some clouds. Can I use wildcards for the 'conditional formatting'. How? thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formating - wildcards
Another way
=ISNUMBER(SEARCH("snow",A1)) will cover any snow -- Regards, Peo Sjoblom (No private emails please) "Terry" wrote in message ... I have a database that has the following items light snow snow sunny partly sunny cloudy some clouds I would like to use conditional formating to show one clour for light snow or snow and another colour for sunny or partly sunny and a third colour for cloudy or some clouds. Can I use wildcards for the 'conditional formatting'. How? thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formating - wildcards
Thanks Chip - worked
"Chip Pearson" wrote: In the CF Dialog, change "Cell Value Is" to "Formula Is" and use a formula like =OR(A1="light snow",A1="snow") Do the same for the other conditions. Of course, change A1 to the cell in question. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Terry" wrote in message ... I have a database that has the following items light snow snow sunny partly sunny cloudy some clouds I would like to use conditional formating to show one clour for light snow or snow and another colour for sunny or partly sunny and a third colour for cloudy or some clouds. Can I use wildcards for the 'conditional formatting'. How? thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
Conditional formating using formulas | Excel Worksheet Functions | |||
can i freeze conditional formating to copy to another worksheet | Excel Discussion (Misc queries) | |||
VLOOKUP & Conditional Formating Help. | Excel Discussion (Misc queries) | |||
more than 3 conditional formating in excel | Excel Discussion (Misc queries) |