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.

ThanksDo you have to have Half Full and Halfe Empty as they are TECHNICALLY the same?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.

ThanksOh I see said the blind man.Quote from: mroilfield on September 03, 2008, 09:17:38 AM

Oh I see said the blind man.