Conditional Formatting with Icon Sets

Originally Posted by NJS1982

I understand it

I'm not sure if that is the case ;-).
Because the formatting responds to relative values not absolute values.

The formatting with icons works that way, that the icon is applied if the cell value is higher than 80% of the range of all values.

So if your values are in say range A1:A100, then icon is applied to all cells with a value higher than

Formula:

min(A1:A100)+0.8*(max(A1:A100)-min(A1:A100))