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" <AhmtDY@discussions.microsoft.com>ha scritto nel messaggio
BE99DF76-C55E-4594-8D24-150E3EF349F3@microsoft.com

> 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" <fra68ve@InVento.it> wrote in message
news:OhO%234QhUFHA.3620@TK2MSFTNGP09.phx.gbl...
> "AhmtDY" <AhmtDY@discussions.microsoft.com>ha scritto nel messaggio
> BE99DF76-C55E-4594-8D24-150E3EF349F3@microsoft.com
>
> > 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)
> --------------------------------------------------------------------------
--------------
>
>