ICON set auto change based on cell value.

[maddison28]

HI,

I Created part of the table below for ease of copy and paste, i dont have the XL2BB.

I am trying to make the icon sets automatically change when the value in column S changes from its current value.

Green arrow: shows an increase in %
Yellow sideways arrow: when there is no change.
Red arrow: when there is a decrease in %

I have been playing with the conditional format but think i need a formular to show changes in the range of numbers like: 1 = an increase, 2 = no change, 3= a decrease.
Then i think i could conditional format based on the numbers. I'm struggling.

Please help.

Thanks

UIC	QTY	NMC	FMC	OR%	Change	DIFF
WMPGAA	404	35	369	91%		9%
WMPJAA	3481	131	3350	96%		4%
WMPKAA	1713	146	1567	91%		9%

 

[bobaol]

Hello, what calculation do you have to determine if Increase, Decrease or No Change? what minus what give the percentage of 91% or 96%? or how is the 9% or 4% calculated? why is the first 91% up, the 96% down, and the second 91% down? I am not seeing how you determine if the change is Increase, Decrease, or Same. As for arrows, I would use conditional formatting. First, the formula in say cell T3 (the 91% with arrow up). I would say, =IF(T3=0,1, IF(T3>0,5,IF(T3<0,6,""))) Then format cell 3 with Wingdings 3 font. try Wingdings 3 on 1, 5, 6 and you will see it will look like arrows. and also font color as yellow. After that, i would use conditional formatting to say if it equals 5 then red. if it equals 6 then green. cheers!