Restrict Input to One Cell or Another Using Data Validation

[Era715]

Hello,

I need to be able to restrict cell input to one cell or another. Meaning if cell R2 is filled, cell S2 should not be filled (vice versa). I want to be able to create an error message if both cells are filled. Our employees should be able to fill in either or cell without restrictions, but both cells cannot be left with values. How can I do this?

[Glenn Kennedy]

DV: Custom, in R2

=ISBLANK(S2)

and in S2

=ISBLANK(R2)

[Glenn Kennedy]

DV: Custom, in R2

=ISBLANK(S2)

and in S2

=ISBLANK(R2)

[Era715]

This worked great! Thank you so much