Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Display each day of the month WH99 Excel Discussion (Misc queries) 4 June 22nd 08 10:07 PM
I want a the to display the Month name only. Nothing else. DAiuto Setting up and Configuration of Excel 3 September 27th 07 12:19 AM
First day and Last day of the month to display automatically mrbalaje Excel Discussion (Misc queries) 1 April 11th 07 02:36 PM
Display Month - 1 HearSay Excel Worksheet Functions 10 September 30th 06 05:18 AM
Display every 3rd category name but still display latest month maryj Charts and Charting in Excel 1 September 24th 06 09:05 PM


All times are GMT +1. The time now is 06:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"