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

B

Belinda

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

Debra Dalgleish

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 Format>Conditional Formatting
From the first dropdown, choose Formula Is
In the Formula box, type: =$D$3=""
Click the Format button
 
Top