Conditional Formatting

[Ada33]

Hi!

I have months listed on cells A3:L3. I want to conditionally format th
cells so that the current month is always highlighted. So, for thi
month, July would be highlighted. Can someone please provide a formul
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

 

[Claus Busch]

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.

 

[Ada33]

Wonderful. Thanks! :