Data Vlidation seems simple

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi to all
I am trying to limit the value entered in A2 to be < = to A1 (the value in A1 comes from a lookup function). In data validation I choose Custom and enter the formula <=A1. I cant enter any value < or > A1. What am I doing wrong
Thanks
 
Hi
-select cell A2
- enter the following formula in the data validation dialog
=A2<=A1
 
Thanks! That got it there was existing Validation int he cell I had to delete it before it would work. Followup question...When I enter the Error Alert, is there any way to reference the value in A1. For instance, If A1 =100 the mesage would say....This value should be less than or equla to 100
Thanks again
 
Back
Top