Highlight entire row if first cell = todays month

[charliew]

Hi there, ive tried everyhting on this and cant get it to work!!

I have a table where in Column A i have the months January, February etc. and data all along to AJ

I want the entire row highlighted or bordered in some way if that row = todays month.

I've tried a couple of VBA codes and conditional formatting and i cant get it to work

[TABLE="width: 583"]
<tbody>[TR]
[TD]January[/TD]
[TD]20[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]68[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]February[/TD]
[TD]27[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]2[/TD]
[TD]85[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]March[/TD]
[TD]37[/TD]
[TD]8[/TD]
[TD]0[/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD]106[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]April[/TD]
[TD]7[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]8[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]May[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]June[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]July[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]August[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]September[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]October[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]November[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]December[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]


thank you!!

 

[njimack]

Conditional formatting:
=$A1=TEXT(TODAY(),"mmmm")

 

[charliew]

My Saviour! Thank you!! I have no idea where i was going wrong lol!!

thanks again!! and thank you sooo much for the ever so speedy reply!!

 

[charliew]

ITS HIGHLIGHTING JUNE!! why is it highlighting june?!

 

[njimack]

ITS HIGHLIGHTING JUNE!! why is it highlighting june?!

It highlighted April for me. It might be your regional settings (today is the 6th).

 

[charliew]

It's me being ditsy! My data starts in A3 so i changed it to

=$A3=TEXT(TODAY(),"mmmm")
And now it is highlighting april! My Fault!

Thanks so much again for your time ​