Is there a way to require a cell to be completed in Excel?

D

dlmurray

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.
 
D

Dave Peterson

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

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

Malcolm Austin

Hi,
can't help on the formula's but my own method is to make the cell
background
bright yellow, that way people can see and pick out what they need to fill
in immediately...

Malcolm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove checked items from To Do lists 0
E-mails disapair from trash 0
Template with fields and premade texts.. 0
Sorting Multiple Tables 1
Weigh tasks 0
Cannot Change Back to Previous Settings After Clicking "Try the new Outlook" 0
Autonumber field in Excel that behaves the same as Access 0
Cumulative formula for word table 0

Top