View Single Post
  #2   Report Post  
Sandy Mann
 
Posts: n/a
Default

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