validate value

i have a data.

all i want to do is to make sure that the the value "From" must be not greater that "To"..it goes the same with the value "To" must be greater than "From".

thanks..

printdata.xls

Try this . I have created two more lists which change as per your input

rgds

johnjohns

nice..can you explain a little bit?

For FROM and TO values, I created two separate lists where the values are generated thru formulas based on your input. Ie when you enter a value in FROM, the ToList automatically changes with values greater than that and same happens for FromList when you enter a value in TO.

rgds

johnjohns

thanks..

does this can be used if the data is over 100++?