View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Neil M
 
Posts: n/a
Default Test display until value

On sheet 1 of my spreadsheet I have a cell whose value is the result of a
formula on sheet 2.
I don't want people to enter text or numbers here but I want to direct them
to sheet 2.
Is there a way to make cell A1 on sheet 1 have text that says "Blah blah
blah" until a value is entered on cell G5 on sheet 2?

Neil M