change shape by condition

L

Libramanuk

I use arrows and basic shapes on presentation worksheets but need to control
the appearance based on cell data. Is it possible to include conditional
formatting of arrows and shapes such that they are not visible when a
nominated cell matches a condition.
ie cell A1 = 5 arrow visible but if A1 = 0 it is not visible.
Thanks in advance for any help you can give
 
T

Tom Ogilvy

No. You would need to use a macro to react to changes in the sheet and make
changes to the appearance of the shapes.
 
D

Don Guillett

right click sheet tab>view code>insert this>modify to suit>SAVE
Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Address = "$A$1" And Target >= 5 Then
ActiveSheet.Shapes("AutoShape 3").Visible = True
Else
ActiveSheet.Shapes("AutoShape 3").Visible = False
End If
End Sub
 
Top