MONTH display

[andrew]

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?

 

[RobN]

Andrew,

Have you checked out conditional formatting?

In there, you should select something that says "Format cells that are equal
to" or similar, and insert =Today() into the field. Then select how you want
it formatted Then apply that cell's formatting across all the other cells.

Rob

 

[andrew]

Hi Rob, i've tried that already. Problem is, if this month is July (from 1st
until 30th) then the cell where i had placed the date (07/01/2008) will only
change colour if today is 1st July 2008. What about the remaining days in the
month?

My objective is to have the cell with the month displayed to remain
highlighted as long as it is equal to the current month. Does it make sense?

 

[T. Valko]

Assume the dates are in the range A1:L1
Select the range A1:L1
Goto Format>Conditional Formatting
Select the Formula Is option
Enter this formula in the little box to the right:

=MONTH(A1)=MONTH(NOW())

Click the Format button
Select the Patterns tab
Select the fill color of your choice
OK out

 

[andrew]

you're on a roll...thanks!

Assume the dates are in the range A1:L1
Select the range A1:L1
Goto Format>Conditional Formatting
Select the Formula Is option
Enter this formula in the little box to the right:

=MONTH(A1)=MONTH(NOW())

Click the Format button
Select the Patterns tab
Select the fill color of your choice
OK out

 

[RobN]

Ahh! Now I see what you ant. But I see you're problem's solved.

Rob

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

you're on a roll...thanks!