I set up a vehicle gas/maintenance log with columns of DATE, MILEAGE,
GALLONS to graph & calculate gas mileage, however I also track routine
maintenance like oil changes, tire rotations etc.

I need help with figuring out how to compare the last MILEAGE value
entered with the latest oil change mileage which will turn red when a
oil change is coming up.

The column lenght increases each time I get gas so how do I reference
the last entered mileage with the fixed oil change mileage?


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/