Linking Information in Sheets based on its content
You could use conditional format so that the foreground colour is set
to the same colour as the background if the cell contents are equal to
zero. Alternatively, the formula;
= IF(Worksheet!B2 = "", "", Worksheet!B2)
Pete
|