conditional formatting by quartile

**casdaq** · 03-10-2010, 12:40 PM

Hello - I need assistance with a conditional formating. I'm attempting to highlight a series of numbers by quartile

Green > 75%
Light Green < 75% >= 50%
Yellow < 50% >= 25%
Red <25%

There is an icon set that will do this for me but I cannot change the color coding to what I need it to reflect.

Any help is greatly appreciated!

**6StringJazzer** · 03-10-2010, 12:55 PM

What version of Excel are you using? I don't have 2003 in front of me but it might have a limit of three rules. You can use Green as the default color then use rules to set the other three colors to exactly what you want. In 2007 just set up four rules. In 2007 there are multiple ways to attack it; I find the simplest to just go to Manage Rules then Add Rule.