Data Validation again...

[Guest]

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.

 

[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)