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/

CodeFunctionName
What is this?

Public

Tested

Original 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 280

Downloads 67

CodeID
DB ID