Validation Q

[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

 

[Bob Phillips]

Use

=A2>A1

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[John]

Thanks Bob

Use

=A2>A1

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)