Conditional formatting icon set

[Rockerdo]

I’m trying to get the icon set to work
If F80 is > F81 red arrow
If F80 = F81 green arrow.
If F80 < F81 yellow

Doesn’t seem to be a way with the way the formulas appear when I’m attempting to do this.

I can turn the cell a color but icon would be more impactful

F81 is the calculated allowed amount off a Vlookup table. F80 is the sum of the amount they’ve entered cells F71 to F78

I’m trying to find a way to get this to stand out. It’s a real problem where the value is under reported or over. If there isn’t a way I can go with a colored box.

[librebel]

Hello @Rockerdo,

The 3 Arrows Icon Set shows the Red ( DOWN ) Arrow as Default, shows the Yellow ( RIGHT ) Arrow when the reference value is Larger Than or Equal To a certain treshold, and shows the Green ( UP ) Arrow when the reference value is Larger Than or Equal To another certain treshold.

So you could do this:

HTH, lib

[Rockerdo]

Thanks. Wish I could switch it. I need the red when they’ve exceeded the allowed amount in F80 not the green. I will have to go with the colored cell
We have done that before and it wasn’t very effective but better than nothing