Thread: If no value in a1 how do I get a2 a3 a4 a5 a6 a7 a8 not to show their vaules
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pano pano is offline
external usenet poster
  
Posts: 84
Default If no value in a1 how do I get a2 a3 a4 a5 a6 a7 a8 not to show their vaules
Hi all,

How do I do this, A1 sheet2 has a date in it linked from sheet1 __ A2
A3 A4 A5 A6 also have links in it from sheet1. I want to be able to if
the date does not appear in A1 that the other cells do not show up as
well or format white or whatever trick anyone knows????


Thanks
Stephen

Reply With QuoteReply With Quote