Data Validation

[john5079]

I am trying to do some data entry error checking using the data validation custom box. I can't seem to get the syntax right. I want to allow entry if the value the data is <C8 or = "out of service". The Value of C8 is 35,000..Can anyone please help?

Thanks,
JC

[Ron Coderre]

See if this works for you (for cell A1):
Data>Validation
Allow: Custom
Formula: =OR(A1<$C$8,A1="out of service")
Click [OK]


Does that do what you want?

Ron

[john5079]

Thanks Ron..works great