Data Validation again...

K

kaci

Hello all,

Thanks for all the advice about the conditonal formating, however, I have
another question regarding data validation.

I would like to set u a control in which when user enters anything in Col A,
it is required that Col B, C, D have to be entered as well.

Please kindly advise.
 
B

Bob Phillips

In the DV use an allow of Custom and a formula of

=AND(B2<>"",C2<>"",D2<>"")

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 
Top