Data Vlidation seems simple

[Lee]

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

 

[Frank Kabel]

Hi
-select cell A2
- enter the following formula in the data validation dialog
=A2<=A1

 

[Lee]

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

 

[Frank Kabel]

Hi
AFAIK no way to use a cell reference in the error dialog