View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lisa Lisa is offline
external usenet poster
 
Posts: 328
Default Data Validation 2003

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