Adding a constraint.
 

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)

"AhmtDY" ha scritto nel messaggio


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

----------------------------------------------------------------------------------------
To reply translate from italian InVento (no capital letters)
----------------------------------------------------------------------------------------

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

--
HTH

Bob Phillips

"Franz" wrote in message
...
"AhmtDY" ha scritto nel messaggio


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

--------------------------------------------------------------------------
--------------
To reply translate from italian InVento (no capital letters)
--------------------------------------------------------------------------
--------------