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!
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.
Making the world a better place one fret at a time
||||||
If someone helped you, please click on the star icon at the bottom of their post
If your problem is solved, please update the first post:
EDIT, Go Advanced button, set Prefix to SOLVED
[code]
' Enclose code in tags like this
[/code]
Don't attach a screenshot--just attach your Excel file! It's easier and will let us experiment with your data, formulas, and code.
I have 2007 but I can't seem to find a good option for what I'm trying to accomplish.
example attached
Making the world a better place one fret at a time
||||||
If someone helped you, please click on the star icon at the bottom of their post
If your problem is solved, please update the first post:
EDIT, Go Advanced button, set Prefix to SOLVED
[code]
' Enclose code in tags like this
[/code]
Don't attach a screenshot--just attach your Excel file! It's easier and will let us experiment with your data, formulas, and code.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks