how do I make a cell in Excel required to be populated?

T

Tia

I am attempting to use Excel for a form I am creating and need to make
certain cells required. I am unfamiliar with Macros, but am thinking this
may be the only way to do this. Thoughts?
 
D

Dave Peterson

You could use a macro that looks at those cells and counts how many are filled
in. But since macros are new, how about an alternative?

Use an adjacent cell.
Put a formula like:
=if(c3<>"","","<----Please fill in this cell")
(I used D3 for this)

Then format it in a nice bright bold red.

The user sees the warning immediately.

If you have formulas that depend on all that cell being filled in, you could
even:

=if(c3="","Cannot calculate until C3 is completed",yourformulahere)

To kind of disable the worksheet's function.
 
Top