How to do conditional formatting of date cell per month?

Hello,

I have Date cell in format YYYY-MM-DD, like 2022-11-11 and I would like to highlight this cell in case month there is current month. So, if there will also 2022-10-01 or 2022-12-05 they will not be highlighted.

I google out it should be possible to do via conditional formatting by Formula, but did not figured out how.
Thank you very much for advise.

Welcome!
It seems to me that you are looking for a formula of the form MONTH(A1)=MONTH(TODAY())

Condition

If the column contains dates for different years, then it is better to use the formula
EOMONTH(A1;0)=EOMONTH(TODAY();0)

2 Likes

Perfect. Thank you very much. Exactly I was looking for. :ok_hand:

1 Like

With C19 being the active cell, relatively referencing the A1 cell looks odd though…

1 Like

Odd in what sense? Need explanation.
The CF manager for a long time now always takes references relative to the top-left cell of the range for which CF is currently edited. This is even true if the range for a new CF was selected with the mouse moving it up and leftwards. “Old” (now AOO) behaviour was “relative to focus cell”.

Humja, true, I still find that thing slightly confusing when seeing… ignore me.