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
|