Conditional format - blank if zero

[Mel Smith]

Hello folks,

I'm trying to put a conditional format into a linked spreadsheet so that if the source cell is blank, the linked cell is also blank rather than displaying a '0'. The cell formular is "=Sheet1!H5" etc.

Your help will be appreciated.

Mel

 

[Marcelo Branco]

Just to clarify a few alternatives as this can be accomplished with conditional formatting two ways:

First way is when the cell value is equal to zero and just set it as white text on white background.

You can also use a custom number format of "" if the cell is equal to 0 so it wont display anything.

The first , i already knew, the second is completely new to me.

Thanks for the tips

M.

 

[Scott Huish]

The custom format should be [=0]""

 

[Marcelo Branco]

The custom format should be [=0]""

Nice!

M.