ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Validation Q (https://www.excelbanter.com/excel-worksheet-functions/80993-validation-q.html)

John

Validation Q
 
I am trying to set a Validation to check to ensure that what has been input
in a cell is higher than another cell.

I have entered within "Custum" validation the following A1

Thus if value in A1 is = 100 what must be entered in A2 is 101 or higher,
but my validation doesn't allow me to enter anything. AM I doing something
wrong?

Thanks



Bob Phillips

Validation Q
 
Use

=A2A1

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"John" wrote in message
...
I am trying to set a Validation to check to ensure that what has been

input
in a cell is higher than another cell.

I have entered within "Custum" validation the following A1

Thus if value in A1 is = 100 what must be entered in A2 is 101 or higher,
but my validation doesn't allow me to enter anything. AM I doing something
wrong?

Thanks





John

Validation Q
 
Thanks Bob

"Bob Phillips" wrote in message
...
Use

=A2A1

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"John" wrote in message
...
I am trying to set a Validation to check to ensure that what has been

input
in a cell is higher than another cell.

I have entered within "Custum" validation the following A1

Thus if value in A1 is = 100 what must be entered in A2 is 101 or higher,
but my validation doesn't allow me to enter anything. AM I doing
something
wrong?

Thanks








All times are GMT +1. The time now is 04:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com