I am using data validation in number of cells. Assume a case where i
have data validation where i have restricted the value in cell no A25
not to exceed a value which is appearing at cell no A24. Now assuming
that the value at Cell A24 is 100 the data validation rightly does not
allow me to feed any value over 100 at cell no A25. Now assuming that I
have fed vale 35 at cell no. A25 it allows me to feed the value. Now in
case if i change the value of cell A24 to 23 no error report is
generated even though the Value at Cell No A25 is 35 which is greater
than the value of 23 as appearing at cell no A24.

please guide