Conditional Formatting: Can't get red dot to show up

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?

Appreciate the response!

In this case, when using icon sets, you do have to do an individual rule for each row (unless there's something I'm not understanding). You can't use relative references with icon sets, so it automatically references cell $L$3 and compares it to every row.

error_message.PNG

As for row 7. I can see now that my math is off, thanks for pointing that out. I should have been using 0.2 instead of 0.8 (and I made sure it said formula instead of percentage). I think that was causing my issues because I am now able to get the red icons to appear. Thank you!

If I'm misunderstanding that error message and there is an easier way to do conditional formatting with icon sets and apply it to an entire row. Could you explain that a little bit?

Thanks again!