Forum Discussion
adamboscoucdenver
Aug 26, 2020Copper Contributor
Conditional Formatting Rules
Hi I am trying to make two graded color scales work together for a set of data using the conditional formatting rules. One graded color scale is for values between 10 and 20, with the second graded...
mtarler
Aug 26, 2020Silver Contributor
adamboscoucdenver sounds like you want a full rainbow of color. I don't believe that is possible (would love to hear someone correct me because that would be really interesting). That said, I assume you are already using 3-Color Scale for each range, because otherwise you might get similar results by using that instead of 2 2-color ranges. The 2 other options for you are then using a lot of custom formula based conditional formatting (ugh even thinking of that) or a custom VBA function that basically does a custom conditional formatting.