Adding/Subtracting Dates and Conditional Formatting
 

I have a worksheet I use for fleet management. One cell has the date
of the last oil change on a vehicle. Using conditional formating, I
would like that cell to turn green when it has been 90 days since the
last oil change.

Can someone please help me with this?

Adding/Subtracting Dates and Conditional Formatting
 

Je 9 Apr 2006 17:36:21 -0700, "Seddie" skribis:

I have a worksheet I use for fleet management. One cell has the date
of the last oil change on a vehicle. Using conditional formating, I
would like that cell to turn green when it has been 90 days since the
last oil change.

Can someone please help me with this?

I'm assuming you know about the format part, and are looking for help
to set the condition.

Cell Value Is, Less Than, =NOW()-90.

The NOW() function will give today's date. The formula subtracts 90
days. The function will be True when the date in the cell is more than
90 days old.

Note that this will not exactly match the date that we usually give as
"90 days", such as in payment terms.

For example, 90 days after June 30 is usually taken to be September
30. However, 90 days later is actually September 28. That can be
programmed too, it just takes a few more steps. It's probably been
done already, as an add-in.

Steven


--
Steven M - lid
(remove wax and invalid to reply)

A fool and his money are soon elected. -- Will Rogers