Conditional Formatting

[Bazola]

Hi All

I am hoping this will be a quick one!

I've got a spreadsheet with some columns in it, at the top it says the date such as Mar-19, next column says Apr-19 and so on. I want to use CF to highlight the current month and the associated cells below column wise. So for example,
Mar-19 is cell D4, the cells I also want to be highlighted as part of it are Cells D5-D8.

Your help is appreciated

 

[Joe4]

=month(c$4)&year(c$4)=month(today())&year(today())

You can also simplify that a little like this:

=TEXT(C$4,"mmyyyy")=TEXT(TODAY(),"mmyyyy")

 

[footoo]

Alternatively :

=EOMONTH(C$4,0)=EOMONTH(TODAY(),0)