Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Mandatory entry for a group of cells?
How do I designate a group of cells as requiring an entry, without using a
macro? |
#2
|
|||
|
|||
I'd use a nice visible cell and format it in big bold red letters.
Say your range you want to check is 3 cells (a1:A3). Then in B1: =if(counta(a1:a3)=3,"","You must enter all three cells") Actually, I like to use an adjacent cell for each cell that must be filled in. =if(a1="","","<-- This cell cannot be left blank!") JB wrote: How do I designate a group of cells as requiring an entry, without using a macro? -- Dave Peterson |
#3
|
|||
|
|||
Hi JB-
In addition to Dave's suggestions, you could just as effectively apply Borders & Shading to put emphasis on the cells and use an adjacent cell or Text Box to display the 'required' message. Keep in mind, however, that you are only "posting a sign". None of these options will actually force a user to put content in the cells before closing the file or going on to do something else. AFAIK that would have to be done with VBA. Good Luck |:) "JB" wrote: How do I designate a group of cells as requiring an entry, without using a macro? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mandatory entry for a group of cells?
hello
try using data validation data-validation... "JB" wrote: How do I designate a group of cells as requiring an entry, without using a macro? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there away to have specific cells unlock based on the entry of information in another? | New Users to Excel | |||
define group of cells | Excel Discussion (Misc queries) | |||
How to create mandatory cells in a worksheet | Excel Worksheet Functions | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
copy group of cells to another group of cells using "IF" in third | Excel Worksheet Functions |