Validation Q

J

John

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
 
B

Bob Phillips

Use

=A2>A1

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top