Conditional Format Row based on Month

[kyddrivers]

I think this should be easy, but I am running into a wall for some reason. Excel is blocking my XL2BB add-in, so I will try to show you what I have and need as best I can.

I have the table below:

• The months are 1/1/2023 formatted as MMM
• May & April are formatted as numbers
• % Change is formatted as a percentage

I want the whole row highlighted and bolded if it's in the next 90 days. Ie rows for May, Jun & Jul should all be highlighted

The highlights above are produced by this formula in conditional formatting.
AND(MONTH(B4)>=MONTH(EOMONTH(TODAY(),2)), MONTH(B4)<=MONTH(EOMONTH(TODAY(),4)))

Data	May	April	% Change
Jan	40,161	22,794	-43%​
Feb	37,781	26,988	-29%​
Mar	47,898	34,424	-28%​
Apr	46,449	37,024	-20%​
May	50,758	39,382	-22%​
Jun	56,428	43,631	-23%​
Jul	61,504	50,482	-18%​
Aug	63,393	49,823	-21%​
Sep	57,994	47,020	-19%​
Oct	53,105	42,976	-19%​
Nov	49,381	40,220	-19%​
Dec	49,589	40,731	-18%​
Grand Total	614,442	475,494	-23%​

Any help is greatly appreciated. And if you have a workaround for XL2BB, I would like to hear that too.

Thanks!

 

[James006]

Hi,
You can test

=AND($A2>TODAY(),$A2<TODAY()+90)

 

[kyddrivers]

Wasn't that easy, it gave me a starting point.

That is currently highlighting Apr-Jun, but

If we tweak it to =AND($H6>TODAY()+30,$H6<TODAY()+120) it highlights May -Jul

Thanks for your help!!

 

[James006]

Glad you could solve your problem