View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nadine nadine is offline
external usenet poster
 
Posts: 216
Default 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