software

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 quot;Custumquot; validation the following gt;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
Use

=A2gt;A1

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Johnquot; gt; wrote in message
...
gt; I am trying to set a Validation to check to ensure that what has been
input
gt; in a cell is higher than another cell.
gt;
gt; I have entered within quot;Custumquot; validation the following gt;A1
gt;
gt; Thus if value in A1 is = 100 what must be entered in A2 is 101 or higher,
gt; but my validation doesn't allow me to enter anything. AM I doing something
gt; wrong?
gt;
gt; Thanks
gt;
gt;
Thanks Bob

quot;Bob Phillipsquot; gt; wrote in message
...
gt; Use
gt;
gt; =A2gt;A1
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;Johnquot; gt; wrote in message
gt; ...
gt;gt; I am trying to set a Validation to check to ensure that what has been
gt; input
gt;gt; in a cell is higher than another cell.
gt;gt;
gt;gt; I have entered within quot;Custumquot; validation the following gt;A1
gt;gt;
gt;gt; Thus if value in A1 is = 100 what must be entered in A2 is 101 or higher,
gt;gt; but my validation doesn't allow me to enter anything. AM I doing
gt;gt; something
gt;gt; wrong?
gt;gt;
gt;gt; Thanks
gt;gt;
gt;gt;
gt;
gt;