Ask Your Question
0

Conditional formatting icon set

asked 2018-01-14 20:04:00 +0200

Rockerdo gravatar image

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.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2018-01-14 21:23:18 +0200

librebel gravatar image

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: image description

HTH, lib

edit flag offensive delete link more

Comments

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

Rockerdo gravatar imageRockerdo ( 2018-01-14 21:42:37 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-01-14 20:04:00 +0200

Seen: 235 times

Last updated: Jan 14 '18