VEhicle Maintenance

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cass - 08 May 2008 20:37 GMT

I know the date that a vehicle needs to go in for it's yearly maintenance and
i want to see if i can cause the cell that the date is in to change color a
month prior to the date....does anyone know if that can be done and how to do
that?

Reply to this Message

Mike H - 08 May 2008 20:55 GMT

Hi,

I'm guessing that this applies to a column of cells so select that column
range then

Format|Conditional format
Select formula is
enter this formula
=AND(A1<>"",A1>TODAY()-30)
pick a colour

Note that the A1 should be the address of the topmost cell of your range
which in your case may not be A1

Mike

> I know the date that a vehicle needs to go in for it's yearly maintenance and
> i want to see if i can cause the cell that the date is in to change color a
> month prior to the date....does anyone know if that can be done and how to do
> that?

Reply to this Message