Thread: Validation Q
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default 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