Oct 08 2019 09:14 AM
Is there a way I can use a conditional formula to highlight a cell if the % value for the cell is NOT within a +/- 20% range based on a comparison % value in cell2. Highlighting if it's positive GREEN and if negative RED. (so it may be two conditional statements)?
Any help is greatly appreciated. Adrian
Oct 08 2019 09:24 AM
Yes, one color - one rule
You may apply conditional formatting rules as here to column A
with formula for RED
and the same but <=0.2 for GREEN