ExcelBanter - Data Validation

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Data Validation (https://www.excelbanter.com/excel-discussion-misc-queries/20564-data-validation.html)

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

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