How do I make someone enter information in a cell

V

Vicky T

I have created a worksheet for my employees to track their daily activies.
Some cells are optional other must be filled out. How do I force these cells
to be used?
 
D

Dave Peterson

I like to use an adjacent cell that is formatted in big, bold red letters:

=if(a1<>"","","<-- Please complete this cell!")

This would go in B1.
 
Top