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.

Hi,

Am Sat, 20 Jul 2013 05:46:16 +0100 schrieb Ada33:

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?

if you have the month names in this range try:
=A3=TEXT(TODAY(),"MMMM")


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Wonderful. Thanks! :)