How do I change cell colors for more than 3 conditions in Excel?

[Laxalife]

Hi,

I am running Windows XP SP2, along with Microsoft Excel 2003.
I am working a project that requires me to create a list. The choices in the list need the background color of the cell to change, based on a condition. I know about conditional formatting, but that only works for 3 conditions. I have 4 conditions that need to be met, so conditional formatting won't work.

So for instance, I have a drop down menu with the words Full, Half Full, Half Empty, Almost Empty, and Empty. I need Full = green, half full = yellow, half empty = orange, almost empty = red.

Can I do this with an "if" formula in excel, or is there an easier way to this?

All help is appreciated.

Thanks

[mroilfield]

Do you have to have  Half Full and Halfe Empty as they are technically the same?

[Laxalife]

I'm using them as an example. So yes I do need them, but I'm just giving them as an example, so people could better understand the situation.

Thanks

[mroilfield]

Oh I see said the blind man.

[Carbon Dudeoxide]

Oh I see said the blind man.

 

[itsme21u]

Had the same problem. Try this site. explains how to do it

http://www.ozgrid.com/VBA/excel-conditional-formatting-limit.htm