Hi!

I have months listed on cells A3:L3. I want to conditionally format the cells so that the current month is always highlighted. So, for this month, July would be highlighted. Can someone please provide a formula that I can enter and also provide the logic?

I am guessing I would have to use an IF function with the TODAY() function but I can't quite figure it out.

Thanks in advance.