Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do I make a cell in Excel required to be populated?
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? |
#2
|
|||
|
|||
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. Tia wrote: 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? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make a 3-dimensional plot in Excel? | Charts and Charting in Excel | |||
How Can I make a cell flash in Excel | Excel Discussion (Misc queries) | |||
excel locks up after selecting a cell | Excel Discussion (Misc queries) | |||
how do i make a cell date sensitive to execute a formula or input. | Excel Discussion (Misc queries) | |||
make a cell empty based on condition | Charts and Charting in Excel |