View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default 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