Do you know that you don't have to create individual rules for each row? Select all rows, create a rule with icon sets and it will apply that ONE rule to all rows.
Your rule in row 5 uses percent, not formula in the definition of the yellow value, so it differs from the rest.
All the other rules work correctly, as in their individual definitions.
for example row 7 is yellow because =L7-L7*0.8 = 5.6 and the value 20 is not smaller than that, so yellow is applied, not red. Red will be applied if the value is less than 5.6.
What is the problem? Do you expect to see something different? Why? Can you explain your rules in words?
Bookmarks