View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dearoledad Dearoledad is offline
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.