![]() |
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 |
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 |
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