| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I make a formula in Excel to display result in same cell? | Excel Worksheet Functions | |||
| Please make it easier to access the IS functions (e.g., isblank) . | Excel Worksheet Functions | |||
| How can i get an If formula in excel to edit another cell? | Excel Worksheet Functions | |||
| Can I make a cell in Excell flash or blink. | Excel Worksheet Functions | |||
| make a cell empty based on condition | Charts and Charting in Excel | |||
Hybrid Mode
