Having a due date flag in a different colour 30 days from current.

[mike099]

I have a maintenance schedule for a fleet of 100 trucks. Not all come due at
the same time. I have a spreadsheet set up now that calculates when the PM's
and Annual Inspections are due but I would like something that stands out
when I look at the list to say yes, this unit is due this month, without
having to go through the whole list and manually pick out the ones due for
Jan. Then next month, have all due in Feb. be highlighted or maybe 5 days
before the new month begins.

 

[Debra Dalgleish]

You can use conditional formatting to highlight the dates in the current
month. For example:

Select the cells that contain dates (A2:A30 in this example)
Choose Format>Conditional Formatting
From the first dropdown, choose Formula Is
In the formula box, type: =MONTH(A2)=MONTH(TODAY())
Click the Format button