Conditional Formatting
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
|