Forum Discussion
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...
adamboscoucdenver Perhaps the attached workbook holds an acceptable solution for you. It uses one 3-color scale for numbers from 10 to 40, after explicitly formatting numbers less than 10, between 20 and 30, and greater than 40 with "no fill".