I have two autoshapes and a particular value in a cell. I want to show a particular autoshape (autoshape1) if cell value < 0 and show autoshape2 if cell value > 0. Any way to do this using formulas and no code?
--
if x > 0,
show autoshape1
else if x < 0
show autoshape2
[implied x=0 show nothing]
--
if x > 0,
show autoshape1
else if x < 0
show autoshape2
[implied x=0 show nothing]