Thread: MONTH display
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Andrew Andrew is offline
external usenet poster
 
Posts: 358
Default MONTH display

Hi, part of my worksheet has the following:

A B C ....
01/01/2008 02/01/2008 03/01/2008 ....

until December. All twelve cells (Jan-Dec) are formatted with mmmm to
display the month text accordingly. I would like the particular cell to be
highlighted with colour of choice when the cell equals to current month. I.e.
if today is within the month of July 2008, the particular cell (07/01/2008)
will have a coloured background. Any ideas?