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.

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)

"kaci" wrote in message
...
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.