change shape by condition

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
No. You would need to use a macro to react to changes in the sheet and make
changes to the appearance of the shapes.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Format Objects? 3
Conditional Format 1
Can one change shape properties conditionally? 1
changing font using conditional formatting 1
conditionally formatting cells based on other cells 1
Excel VBA 1
Conditional formattting & CountColorCells 6
Hiding cells based on the value in another cell 3

Back
Top