Excel 2007 - Validation

N

Nadine

Is it possible to...make a cell a required field to fill in if there is an
entry in another field. As a type of data validation.

i.e In B3
If B6 is not blank, make B3 a mandatory cell to fill in.

B6 thru to B22 have data validation to choose from a list True, False, NA

looking for, if any of the cells in that range are not blank, ensure they
enter the file number in cell B3

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 - Validation 1
Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0
Formula fill series? 1
Combo box 0
Data Validation List 1
drop box/data validation help 0
find blank cell and replace with " ' " 2
INDIRECT Formula 3

Top