Data Validation with IF/OR formula

[BoilerMan691]

Hello,

I am trying to write a Data Validation formula where if C7=N then D7 MUST =N, but if C7=Y then D7 can =Y or =N. Any help would be much appreciated!

Thanks,
James

 

[pjmorris]

only your users can convince you its fool proof! Glad its working and thanks for letting us know.