G
Gareth
Debra
Many thanks for this, it works fine. One problem I have with it is that the
range "dob" extends further, ie, it contains about 200 rows of empty cells
which the user will complete.
The validation is there but when the user checks for validation errors
(Tools | Auditing | etc) it will show up errors in these cells until he/she
enters data. Is there any way to amend the formula to avoid seeing any
errors in the blank cells in range "dob" (column I)?
Gareth
Many thanks for this, it works fine. One problem I have with it is that the
range "dob" extends further, ie, it contains about 200 rows of empty cells
which the user will complete.
The validation is there but when the user checks for validation errors
(Tools | Auditing | etc) it will show up errors in these cells until he/she
enters data. Is there any way to amend the formula to avoid seeing any
errors in the blank cells in range "dob" (column I)?
Gareth