View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tony tony is offline
external usenet poster
 
Posts: 313
Default Data Validation Using "IF" Function?

I am trying to set up a custom validation for cell A2, so that if A1 reads
"YES" A2 must be a specific formula. If A1 reads "NO" A2 can be anything
else.

Any suggestions?