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

 

[VoG]

Try just

=M3<5

 

[andrewb90]

Thanks, that seemed to work.
One of my cells has words in two different colors and the colors will not change. Any way around that?
Also I have a button in/on one of the cells. Any way to cover and/or hide it as well?

 

[VoG]

Hmm. I just tried that and it appears that manually coloring the font seems to take precedence over CF. I don't believe it is possible to hide objects like buttons using CF.

 

[andrewb90]

Is it possible to move or alter a button? If not is it possible to assign macros to cells instead of objects?

Thanks,

Andrew

 

[VoG]

This worked for me: right click the sheet tab, select View Code and paste in

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address(False, False) = "M5" Then Me.Buttons("Button 1").Visible = Target.Value >= 5
End Sub

change the name of the button to suit.

 

[andrewb90]

Am I suppose to assign a name to my button? I am not sure how to go about that.

 

[VoG]

No, you need to change Button 1 in the code to the actual name of your button.

 

[andrewb90]

How do I know what my button is called? Unless it is the name of the macro assigned to it.

 

[VoG]

Is this a regular button (from the Forms toolbar) or an ActiveX button (from the Controls toolbar)?

For a regular button, click on it and its name will be displayed in the Name Box.

For an ActiveX button, go into Design Mode then click the button to display its name in the Name Box. this type of button would require different code.