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?

MONTH display
 

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" wrote in message
...
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?

MONTH display
 

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?

"RobN" wrote:

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" wrote in message
...
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?

MONTH display
 

Assume the dates are in the range A1:L1
Select the range A1:L1
Goto FormatConditional 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

--
Biff
Microsoft Excel MVP


"andrew" wrote in message
...
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?

MONTH display
 

you're on a roll...thanks!

"T. Valko" wrote:

Assume the dates are in the range A1:L1
Select the range A1:L1
Goto FormatConditional 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

--
Biff
Microsoft Excel MVP


"andrew" wrote in message
...
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?

MONTH display
 

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

Rob

"andrew" wrote in message
...
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?

"RobN" wrote:

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" wrote in message
...
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?

MONTH display
 

You're welcome!

--
Biff
Microsoft Excel MVP


"andrew" wrote in message
...
you're on a roll...thanks!

"T. Valko" wrote:

Assume the dates are in the range A1:L1
Select the range A1:L1
Goto FormatConditional 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

--
Biff
Microsoft Excel MVP


"andrew" wrote in message
...
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?