I need to use multiple rules with conditional formatting. But when I use the graded color scale, it only uses the first rule and ignores the rest. Am I doing something wrong? I have attached the test spreadsheet I am using. Note that the second rule seems to be ignored. Thanks.

Attached Files

Format_test.xlsx (16.7 KB, 12 views)