How do I make a particular column required in Excel?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

smistretta - 24 Apr 2006 17:53 GMT

Our NPO is creating a reimbursement chart in Excel. We're trying to make it
so that if employees do not fill in one particular column entitled
"Projects," they will get an error or will be unable to have a final sum
filled in.

Is there any way I can make this particular column required so that if it is
not filled in, the chart will not complete properly?

Thank you in advance for any advice or help!

Reply to this Message

Elkar - 24 Apr 2006 20:58 GMT

You could use an IF Statement in your final sum. Something like:

=IF(B10="","Please complete Column B",SUM(C1:C10))

Change cell references and messages to suit your needs.

HTH,
Elkar

> Our NPO is creating a reimbursement chart in Excel. We're trying to make it
> so that if employees do not fill in one particular column entitled
[quoted text clipped - 5 lines]
>
> Thank you in advance for any advice or help!

Reply to this Message

Bob Phillips - 25 Apr 2006 11:56 GMT

You could also use Data Validation in the Projects cells with a type of
Custom and a formula of say =B10<>"" (for row 10). Make sure you uncheck the
Ignore Blanks box.

Signature

HTH

Bob Phillips

(remove nothere from email address if mailing direct)

> You could use an IF Statement in your final sum. Something like:
>
[quoted text clipped - 14 lines]
> >
> > Thank you in advance for any advice or help!

Reply to this Message