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

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

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

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