Thread: IS THERE A WAY TO HAVE CELLS IN AN EXCEL SPREADSHEET REQUIRE DATA?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default IS THERE A WAY TO HAVE CELLS IN AN EXCEL SPREADSHEET REQUIRE DATA?
I just like to use an adjacent cell and inform the user:

=if(a1<"","","<--- Please enter something!!!")

Format it nice big bold red letters.



LAKEISHA M. wrote:

IS THERE A WAY TO HAVE CELLS IN AN EXCEL SPREADSHEET REQUIRE DATA?

--

Dave Peterson
Reply With QuoteReply With Quote