J
JB
How do I designate a group of cells as requiring an entry, without using a
macro?
macro?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave Peterson
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!")
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!")
C
CyberTaz
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 |:>)
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 |:>)
D
DawnTreader
hello
try using data validation
data->validation...
try using data validation
data->validation...