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