Highlight row of current month

Highlight row in Excel if it is within current month
This is another version of Excel trick used in our sister website XLFxs.com
http://xlfxs.com/highlight-dates-dynamically/


Public

Tested

My Own Work
This is not a code perse, it is actually a combination of Conditional formatting and Excel functions to highlight a row if a column is within the same month of current month.

It assumes you have a row per month, and we want to highlight the row of current month, to attract our attention fast.

Once you add conditional formatting as formula, paste formula
=AND(MONTH($D1)=MONTH(TODAY()),YEAR($D1)=YEAR(TODAY()))

Make sure you select entire column in Applies to box

Views 103 Downloads 21

VBA-Excel Date+Time
ANmarAmdeen
810
Attachments
Revisions

v1.0