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!
 

Some videos you may like

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

VBE313

Well-known Member
Joined
Mar 22, 2019
Messages
506
Office Version
365
Platform
Windows
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:

Watch MrExcel Video

Forum statistics

Threads
1,095,518
Messages
5,444,949
Members
405,306
Latest member
prueheln

This Week's Hot Topics

Top