View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete
 
Posts: n/a
Default 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