Conditional Formatting - Icon Set

adamjon92

New Member
Joined
Dec 8, 2015
Messages
21
Good afternoon everyone,

I'm thinking this is an easy question but I'm having a brain fart and can't figure it out. Basically I have a spreadsheet where I need to have a red light whenever the percentage is less than -8% and a green light whenever the percentage is more than 8% and have no lights whenever the percentage is between -8% and 8%.

Is it even possible to use negative percentages for conditional formatting?

Thanks in advance!
 

VBE313

Board Regular
Joined
Mar 22, 2019
Messages
86
Assuming you want to start with A1, in conditional formatting write =IF($A1<-.08,1,0) and then make the fill color red. Then add another conditional formatting that is =IF($A1>.08,1,0) then make that fill color green
 
Last edited:

Forum statistics

Threads
1,077,784
Messages
5,336,328
Members
399,076
Latest member
vullistax

Some videos you may like

This Week's Hot Topics

Top