Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Display each day of the month | Excel Discussion (Misc queries) | |||
I want a the to display the Month name only. Nothing else. | Setting up and Configuration of Excel | |||
First day and Last day of the month to display automatically | Excel Discussion (Misc queries) | |||
Display Month - 1 | Excel Worksheet Functions | |||
Display every 3rd category name but still display latest month | Charts and Charting in Excel |