Conditional format if cell=0 then font colour same as background .
 

I have linked a cell from another sheet. If the original cell is blank, 0
shows in the linked cell (text would be typed in source cell).

To handle this, I conditionally formatted the linked cell, so if it equals
zero, the font colour is the same as the background colour of the cell so you
can't see the zero

But the zero still prints even though it is not showing prior to printing

Try the formula

=IF(Sheet1!F14="","",Sheet1!F14)

in the linked cell.

HTH

Sandy

--
to e-mail direct replace @mailintor.com with @tiscali.co.uk


"Paligap" wrote in message
...
I have linked a cell from another sheet. If the original cell is blank, 0
shows in the linked cell (text would be typed in source cell).

To handle this, I conditionally formatted the linked cell, so if it equals
zero, the font colour is the same as the background colour of the cell so
you
can't see the zero

But the zero still prints even though it is not showing prior to printing

I don't have a printer here to test this on, but have you tried formatting
the cells so that a zero appears as a zero string?

Try this format for the cells you are trying to print.
General;General;""

The trick is for the part after the second semicolon to be "". That should
make cells that contain a zero display nothing.

Explicit directions:
Select the cells in question.
Format | Cells |Number | Custom. Type something like General;General;""
Or, pick a number format of your choice and change the end to ""


tj
"Paligap" wrote:

I have linked a cell from another sheet. If the original cell is blank, 0
shows in the linked cell (text would be typed in source cell).

To handle this, I conditionally formatted the linked cell, so if it equals
zero, the font colour is the same as the background colour of the cell so you
can't see the zero

But the zero still prints even though it is not showing prior to printing