Let A1 have the vehicle's last PM date
In another cell use =IF(TODAY()-A190,"PM needed","")
Or use this formula in a conditional format (Format|Conditional Format) to
make the row red.
If B1 has mileage of last PM and B2 has current mileage =IF(B2-B12999,"PM
needed","") will work
Also =IF(OR(TODAY()-A190, B2-B12999),"PM needed","") will cover both
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"audiophile" wrote in message
...
Does Excel offer a way to alert you of a change in data?

I am responsible for the tracking and maintenance of our fleet of
vehicles.
I would like to know if there is ANY way to set-up a spreadsheet so that
every 3 months or 3,000 miles, Excel will let me know that the vehicle is
ready for Preventative Maintenance service.

Any suggestions? I hope I'm not the only one who has every been curious
about this.

I have already tried to work a bit with conditional formatting but not
with
much success.