Adding a constraint.

[Guest]

Is it possible to add a constraint that makes a cell cannot be equal to any
number or any other cell.
i.e. (A1<>3) or (A1<>A2) or (A1<>A2:A5)

 

[Franz]

Is it possible to add a constraint that makes a cell cannot be equal
to any number or any other cell.
i.e. (A1<>3) or (A1<>A2) or (A1<>A2:A5)

You can try using Data Validation.

--
Hoping to be helpful...

Regards

Franz

 

[Bob Phillips]

see http://www.contextures.com/xlDataVal01.html for a starter