I have created a list in column E which contains 3 values

I assume that means it's a data validation list?

Let's assume the selections for this list a Yes, No, Maybe

Put these values in a range of cells, say, J1:J3

Give the range J1:J3 a defined name, say, List.

Let's assume the data validation list is in cell E1 and you don't want it to
work unless an entry is made in cell C1.

As the source for the drop down list in cell E1 use this formula:

=IF(C1="",NA(),List)

When you're setting this up and you get a message that says something like:
the source currently evaluates to an error......

Just answer: Yes

--
Biff
Microsoft Excel MVP


"Lisa" wrote in message
...
Hi
I have created a list in column E which contains 3 values. If the use
selects a value from this list, but the cell on column C is blank (also a
list), I want to issue a warning to the user to tell them to put a value
column C (which is also a list) before they can pick from the list in
column
E. I presume I must use data validation for this, and have been
experimenting, but I'm not sure how to combine the original list and an
'if'
formula within the same rule

Would appreciate any help
Thanks