Is it possible to do conditional formating for two graded color scales over the same cells?
For example I wish to conditionally format a cell such that its color is:
Green to Blue graded scale for values 0 through 10 and Red to Yellow graded color for values 10 to 20.
If I in enter two seperate 2-color scale rules, it doesn't work, as each rule applies to every possible value (you can only specify the points at which the grading starts and end – the start and end color apply to all values outside of those ranges).
I wish for the start and end color not to apply outside of the grading range, so that they can be graded with a subsequent rule.
Is this possible?
Best Answer
All right, I got kind of sick of this question sticking out there. I wrote this macro, it sorts ascending, divides the non-blank range in half (rounded up) and applies two color scales. Modify as you wish.