Sep 27 2021 08:35 AM
Can anyone please help me understand why the conditional formatting is not working properly.
Sep 27 2021 09:08 AM
SolutionThe 69.5 and 59.5 in the rule do not refer to the values in the cells, but they specify that the bottom 59.5% of the data will be red, the next 10% yellow, and the rest green.
Change the rule to refer to the numbers 0.695 and 0.595 (corresponding to 69.5% and 59.5%):
Sep 27 2021 09:08 AM
SolutionThe 69.5 and 59.5 in the rule do not refer to the values in the cells, but they specify that the bottom 59.5% of the data will be red, the next 10% yellow, and the rest green.
Change the rule to refer to the numbers 0.695 and 0.595 (corresponding to 69.5% and 59.5%):