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 - 28 Nov 2006 09:59 GMT
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)
> Hello all,
>
[quoted text clipped - 5 lines]
>
> Please kindly advise.