Hide value 0-0 (0)

[sirdon]

Hi all,

I know how to hide cells that contain zero by using the 0;-0;;@

How do I hide cells that contain 0-0 (0)

Thanks

[NeedForExcel]

Hey!

Is this 0-0 (0) a Value that is going to appear in a cell??

[FDibbins]

Perhaps, if you dont have too many cells to apply this to, use Conditional Formatting with a setting of white on white?

[sirdon]

Yes it is a value that will appear in a cell, but I want it hidden until the number changes for example 0-0 (0.1). In other words any value can be seen except 0-0 (0).

To answer the next question yes I have been using the Conditional Formatting , but I have it across hundreds of cells so it is taking some time. plus every second line (row) is highlighted grey.

[NeedForExcel]

Ok!

If the result is coming from a Formula, you can use something like this -

=IF(A1="0-0 (0)","",A1) (Alter the Cell as required)

Else Conditional Formatting -

=A1="0-0 (0)" (And any formatting that you want)

Hope it helps..

Deep

[sirdon]

yep....I managed to get it to work. I used a conditional formatting. If cell contains (equals to) "0-0 (0)" i formatted the cell to a custom ;;;.
Not sure i explained myself well enough but hopefully you get it.

[NeedForExcel]

Happy to hear..

Deep