Conditional format current month and the next 2 months

[mickyd67]

Hi All,

Any kind soul help me with this one?

I know you can conditionally format dates in the future etc, but it only goes out to the following month.

If I wanted to highlight June, July & August, as of today, is there a formula / condition I can use to do that?

 

[Joe4]

Edit - OK, I'll try the above

It all is dependent on your data layout.
Where do these dates exist (what is the range)?

You would select the range you want to apply this Conditional Formatting to, and then enter the formula as it relates to the very first cell in your selected range.
So the formula we gave you is if cell A2 is the first cell in your selected range.

=AND(A2>TODAY(),A2<=EOMONTH(TODAY(),2))

If the first cell in the range you selected is different than A2, you need to change A2 to that cell address.

 

[mickyd67]

Got this one to work!

Many thanks

=AND(A2>TODAY(),A2<=EOMONTH(EDATE(TODAY(),2),0))

 

[Joe4]

You are welcome!
Glad we were able to help!