Conditional Formatting - Making cells invisible

[andrewb90]

Hello All,

I am trying to enter a formula into conditional formatting that makes a certain cell range 'disappear.' Since I am pretty sure I can't hide individual cells, I am trying to turn all the text fill and borders white to become unnoticeable. My formula I am using is this:
=IF+$M$3<5
I have the effects that I want selected to take place if M3 is any number less than 5 but I don't seem to see anything happening.

Any suggestions would be great.
(Using Excel 2010)

Thanks,

Andrew

 

[andrewb90]

I had just inserted a shape and then assigned a macro to it.
I'm sorry if I'm completely leading you the wrong way with this, These kinds of things are not my strong suit in Excel.

- Andrew

 

[VoG]

Click on the shape. what name is displayed in the Name Box?

 

[andrewb90]

Ah, Ok. Rounded Rectangle 52

 

[VoG]

Try this

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address(False, False) = "M5" Then Me.Shapes("Rounded Rectangle 52").Visible = Target.Value >= 5
End Sub

 

[andrewb90]

Awesome!

Peter, Thank you for all of your help!