In which cell are you using this data validation?

Esrei wrote:
The value in D8 is not a formula if I use < (not equal
to) in a data validation custom formula it does not work
when I change the value but if I only use < or it works
why
In other works if the formula is D8<1.5 and I change the
value to 1 it error message apears but if the formula is
D8<1.5 no matter how I change the value no error apears
Thankx


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html