Is there a way using a Formula to remove all formatting such as borders etc if a test is false?

[RudeBoy]

I have a test to remove the data if it is <> to 0 but the formatting remains for my labels so I wanted to even remove the borders around a cell if the formula is false.
Is there a way to do this?

Thanks for the advise.

 

[Scott Huish]

<>0 would be TRUE. Not sure what you mean by if the formula is FALSE.
It sounds like you want to remove the border no matter what.

You didn't give any specific but something like this perhaps:

Sub test()
Range("C2").Borders.Value = 0
End Sub

 

[RudeBoy]

<>0 would be TRUE. Not sure what you mean by if the formula is FALSE.
It sounds like you want to remove the border no matter what.

You didn't give any specific but something like this perhaps:

Sub test()
Range("C2").Borders.Value = 0
End Sub

Let me explain a bit on what I am doing:

I created Labels in Excel with boxes etc boarders.
I have a test if my input is blank I do not push the blank spaces to the labels.
But what happens is I end up with my borders which creates wasted labels as it will print the borders etc.

No big deal but I thought there was a way to remove boarders in my formula.

Here is my formula I am using & a screen shot of everything showing the issue:

=IF($O19<>0,"Mixed Dbl WOMEN"," ")

Thanks for any & all help