Show month in different color?

[Guest]

I use excel at work and we have gages that are due calibration. I wanted to
know how to put in a formula or something to show each gage that is due in
red at the current month. That way when the next month comes the gages due
that month are in red and the other months are normal.

 

[Mangesh Yadav]

Use conditional formatting.
A1 has the date, B1 has the gage parameter / reading
Select B1. Go to format > conditional formatting. Select 'Formula is'. And
enter in the box:
=MONTH(A1)=MONTH(TODAY())
click on format button and in patterns tab select the red color.

Mangesh