View Single Post
  #2   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 require a cell to be completed in Excel?

I use an adjacent cell that's formatted in a big bold read font:

=if(a1<"","","<-- Please fill in this cell")



dlmurray wrote:

I know that you can require a cell/field to be completed in Access, but was
wondering if there was a way to do the same in Excel.


--

Dave Peterson