Data Validation Using "IF" Function?

T

Tony

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?
 
Top