Thread: Validate entry based on another cell value
View Single Post
  #1  
Old May 15th, 2009, 06:06 PM posted to microsoft.public.excel.misc
Dearoledad
external usenet poster
  
Posts: 10
Default Validate entry based on another cell value
How do I set up validation of data entry in cell B1 depending on the value
entered in cell A1? Valid entries for B1 are - blank if A1 1 or N or E if
column A1 zero.