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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
I use an adjacent cell that's formatted in a big bold read font:

=if(a1<>"","","<-- Please fill in this cell")
 
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
 
You must log in or register to reply here.

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

How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Excel Making a cell Mandatory 9
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Can Anyone Suggest a Way to Remove a Password from a PST File Without Outlook? 1
Require a cell to be completed based on another cell's value 1
Is there a way to prevent pasting data into an Excel worksheet? 16
Red cell for negative numbers in Excel 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2

Back
Top