How do I make a cell required to edit in Excell?
 

I created a template Accounting Sheet for my office to use but they
constantly forget to fill in the date. How can I make that field required to
edit before saving?

How do I make a cell required to edit in Excell?
 

You could use conditional formatting to fill the other fields with
black, unless the date cell has a value in it.

For example, if the date goes in cell D3:

Select the other cells where data should be entered
Choose FormatConditional Formatting
From the first dropdown, choose Formula Is
In the Formula box, type: =$D$3=""
Click the Format button
On the Pattern tab, select the black colour
Click OK, click OK

Belinda wrote:
I created a template Accounting Sheet for my office to use but they
constantly forget to fill in the date. How can I make that field required to
edit before saving?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html