View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Mandatory Input of a Cell

I'd use an adjacent cell that was formatted in big bold red letters:

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

newfie51971 wrote:

I have an input template in Excel 2002 that other users will update with
information. I want to make sure they input a description beside the number.
How can I make the description cell a mandatory input if they input a number?

Thanks,
Tammy


--

Dave Peterson