In Excel 2007, I am trying to apply a validation rule for a cell with multiple conditions. I am selecting custom validation in the validation selection box and my formula is:

=IF(OR(B2="off", B2="not available", B2="request off"), " ")

I want the cell to be blank if B2 has the value "off", "not available" or "request off", and for the cell to be allowed to be any other time value if B2 is not one of the three criteria. This is an employee schedule and I am trying to set it up so that if a person is supposed to be off, the scheduler is not able to insert a shift for them.

What am I doing wrong with the above formula? Should I be doing something else instead of this formula?

Thanks!

Mayrie