MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by MARK CHANDLER on July 23, 2001 1:18 AM

I am trying to make a formula. I have a fuel sheet, which driver's fill in. They have to input the starting figure, and the ending figure. The next driver then has to fill in the same details. I need to put the data from the sheet to the PC. Now, if there is a decrepancy - for example, ending figure 1200. Next driver inputs starting figure as 1190. I need an error message to pop up. How can I do this? Please help - it's doing me head in!!!

Posted by Aladin Akyurek on July 23, 2001 1:43 AM


Lets say that the starting figures are entered in column A and ending figures in B. Lets assume that A1 and B1 are already filled in by some driver. I also assume that the figures to be filled in is associated with the same vehicle.

Activate A2. A2 must be empty!
While in A2, activate the option Data|Validation.
On Data Validation dialog, select Custom for Allow.
As Formula, enter: =A2>=B1 [ or: =A2=B1, depending on whether you allow a new starting figure higher than the last ending figure. ]
Copy down A2 (which is empty but containing the specified data validation) as far as needed.

Note. You can also specify messages on Data Validation dialog by using tabs which are available.