Excel 2007 - Validation
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
|