Validation in excel

[Rugby Man]

Hi, I am have been dumped with some work that is beyond my knowledge
and would wecome any help.

I want to use validation to not allow data entry if another cell is
blank. I have various routes but no joy. This will be the first of
many questions I feel. Hope to hear from you soon.

Regards

Rugby Man

 

[Bob Phillips]

Just use Data Validation with a custom type, and a formula of say

=C1<>""

Uncheck the Ignore blank box.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Rugby Man]

Just use Data Validation with a custom type, and a formula of say

=C1<>""

Uncheck the Ignore blank box.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)







- Show quoted text -

Thanks for that but the only problem I now have is that my error
messages dont work. Any advice please?