use conditional format to highlight current month

[still learning]

Hi
I have in N79:N100 the last day of each month>>N79= June 30, 2019...N80=July31, 2019...N81=Aug 31, 2019...etc
I can't figure out how to write a conditional format to highlight the current month

Example:

This being July, I want to Highlight N80
after July 31, I want to that cell to go back to default and N81 gets highlighted
and continue like that till N100



mike

 

[JoeMo]

1. Select N79:N100 with your mouse.
2. Home>Conditional Formatting>New Rule>Use a formula
3. Formula is: =AND(MONTH($N79)=MONTH(TODAY()),YEAR($N79)=YEAR(TODAY()))
4. Choose the format you want and press OK.

 

[still learning]

Hi JoeMo

thank you


mike

 

[JoeMo]

Hi JoeMo

thank you


mike

You are welcome - thanks for the reply.