Formula for if a cell does not equal 0

[andrewb90]

I am looking for a formula for if B2,C2, or D2 does not equal 0, after that my data validation should work.

Thanks,

Andrew

 

[Michael M]

Also, have a look here at Conditional Data Validation.

http://www.contextures.com/xlDataVal07.html

 

[andrewb90]

When i try to type in those cells I get a popup saying the value I have entered is not valid, a user has restricted values that can be entered into this cell.
Was I putting this in Data Validation still?