How to select colors for different % values for Conditional Formatting?
I have a list of 26 different percentages that change daily.
I would like the values OVER 100% to be BLUE (bonus if font is white and bold too), values between 80-99.99% to be shades of green, 0-25% to be shades of red, and 26-79% to be different shades going from RED to GREEN.
Will excel let me pick custom colors like this when the values fall under certain criteria of my choosing?
CF allows you to pick a color, but it would be 1 rule for each color. If you want different shades of red, each shade would need it's own rule and it's own value (or range)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
It sounds to me like you want a gradient for each interval. That is,
you want 80% to be dark green and 99% to be light green, something like that.values between 80-99.99% to be shades of green
I thought this would be a piece of cake but when I applied a two-color gradient rule it applied the rule to all percentages, not just the interval I specified. So that isn't going to solve your problem.
twocolor CF.JPG
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
i had the same issue - and played with a few other options last couple of days - since question asked - and i could not find a solution - other than setting White as the lowest colour of 79% and then it dis show light green at 80%
BUT I was then unable to set another colour scale for the RED etc
But setting White as the lower colour - does seem to work ok
White at lower point 0.8 and white at midpoint 0.8 then 1 at max point
Last edited by etaf; 10-19-2022 at 11:45 AM.
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks