Conditional formatting

**RageWizard** · 10-15-2009, 04:35 PM

Hey people, and thanks for your guruism in advance.

I would like to take a column of percentages and use the conditional formatting to determine which one of the column of percentages has the highest and lowest percentage. Each cell will have a different color associated with it, but I don't want the columns to be rearranged.

Can someone help me?

**RageWizard** · 10-15-2009, 04:47 PM

I can't believe it, Iactually figured it out on my own, thanks a bunch anyways.

**Paul** · 10-16-2009, 12:07 AM

Hi Rage,

Glad you figured it out for yourself, well done! If you wouldn't mind, could you share your solution with the forum? It will hopefully help others in their search for answers.

Thanks!

**RageWizard** · 11-10-2009, 03:14 PM

Boy, I'm on top of things aren't I, it only took me a month to get back here. I have attached my solution to my own question, and I have another question to go with it.

My next question is: I'm not happy with the conditional formating that I have attached. I would like to use 4 parameters. One that returns the highest percentage, one that returns the lowest percentage, one that colors the boxes when the percentage is above 50%, and one that colors the boxes a different color when the percentage is lower than 50%. I have 4 parameters to look at. Now I know that I can make all of the cells in question one format, and just specify the other 3 to change as I need them too, but this seems to defeat the purpose of this discussion. What happens when I would like 5 parameters a little later in life which will be a totally different color when the cell is equal to exactly 50%?