Show autoshape based on cell value

KrisLB

New Member
Joined
Jan 18, 2005
Messages
42
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]
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

KrisLB

New Member
Joined
Jan 18, 2005
Messages
42
Positioning and auto-aligning objects

Does anyone know if any alignment or auto-positioning tools/options exists for these objects?

I have a list of centered financials. I am wanting a positive arrow to appear immediately before a measure to signify an increase, and a negative/downward arrow to signify a decrease. If I align all the arrows vertically, not a problem, but since the sheet requires the arrows to be spaced close to the the individuals measures, anyone aware how to do this?

----

<arrow> $1.1 billion
<arrow> $5.0 billion
<arrow> 1.25%
<arrow> 723

vs.

<arrow> $1.1 billion
<arrow> $5.0 billion
<arrow> 1.25%
<arrow> 723
 

Watch MrExcel Video

Forum statistics

Threads
1,119,271
Messages
5,577,124
Members
412,769
Latest member
VK12345
Top