Cells B1:D1 have a date format: Jan-05, Feb-05, Mar-05 (mmm-yy). If the month
is the current month, I would like to have that month and the four cells
immediately below that month highlighed. For example, since March is the
current month, I would like cells D1:D5 highlighted. The highlighting would
roll automatically based on the current month.

Thanks,
--
Howard

Howard

Use conditional formatting

Select B1:D5
FormatConditional Formatting
Change Condition1 to Formula Is
Add a formula of =MONTH(B$1)=MONTH(TODAY())
Click Format
Select the pattern tab
Select a colour

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Howard" wrote in message
...
Cells B1:D1 have a date format: Jan-05, Feb-05, Mar-05 (mmm-yy). If the
month
is the current month, I would like to have that month and the four cells
immediately below that month highlighed. For example, since March is the
current month, I would like cells D1:D5 highlighted. The highlighting
would
roll automatically based on the current month.

Thanks,
--
Howard

Howard

I can help you identify the current month but no more. Maybe someone else
can do it more elegantly.

Let's say you are evaluating cell B1

B2: =IF(MONTH(A2)=MONTH(TODAY()),"Current","")

Will return "Current Month" if it's the current month. Otherwise, will
return a blank.

"Howard" wrote:

Cells B1:D1 have a date format: Jan-05, Feb-05, Mar-05 (mmm-yy). If the month
is the current month, I would like to have that month and the four cells
immediately below that month highlighed. For example, since March is the
current month, I would like cells D1:D5 highlighted. The highlighting would
roll automatically based on the current month.

Thanks,
--
Howard

Howard

BTW, I assume that B1:D1 have a real date, not just text. If it is text, try
a formula of

=PROPER(LEFT(B$1,3))=TEXT(TODAY(),"mmm")


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bob Phillips" wrote in message
...
Use conditional formatting

Select B1:D5
FormatConditional Formatting
Change Condition1 to Formula Is
Add a formula of =MONTH(B$1)=MONTH(TODAY())
Click Format
Select the pattern tab
Select a colour

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Howard" wrote in message
...
Cells B1:D1 have a date format: Jan-05, Feb-05, Mar-05 (mmm-yy). If the
month
is the current month, I would like to have that month and the four cells
immediately below that month highlighed. For example, since March is the
current month, I would like cells D1:D5 highlighted. The highlighting
would
roll automatically based on the current month.

Thanks,
--
Howard

Howard

Thanks!
Yes, it has a real date (mmm-yy). That did highlight the current month. Is
there a way to have the four cells immediately below the cell with the
current month also highlighted? Those cells would have numbers.

Howard

"Bob Phillips" wrote:

BTW, I assume that B1:D1 have a real date, not just text. If it is text, try
a formula of

=PROPER(LEFT(B$1,3))=TEXT(TODAY(),"mmm")


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bob Phillips" wrote in message
...
Use conditional formatting

Select B1:D5
FormatConditional Formatting
Change Condition1 to Formula Is
Add a formula of =MONTH(B$1)=MONTH(TODAY())
Click Format
Select the pattern tab
Select a colour

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Howard" wrote in message
...
Cells B1:D1 have a date format: Jan-05, Feb-05, Mar-05 (mmm-yy). If the
month
is the current month, I would like to have that month and the four cells
immediately below that month highlighed. For example, since March is the
current month, I would like cells D1:D5 highlighted. The highlighting
would
roll automatically based on the current month.

Thanks,
--
Howard

Howard

If you select B1:D5 as I originally stated, it will apply to al cells, and
so the 4 below are formatted as well

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Howard" wrote in message
...
Thanks!
Yes, it has a real date (mmm-yy). That did highlight the current month.
Is
there a way to have the four cells immediately below the cell with the
current month also highlighted? Those cells would have numbers.

Howard

"Bob Phillips" wrote:

BTW, I assume that B1:D1 have a real date, not just text. If it is text,
try
a formula of

=PROPER(LEFT(B$1,3))=TEXT(TODAY(),"mmm")


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bob Phillips" wrote in message
...
Use conditional formatting

Select B1:D5
FormatConditional Formatting
Change Condition1 to Formula Is
Add a formula of =MONTH(B$1)=MONTH(TODAY())
Click Format
Select the pattern tab
Select a colour

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Howard" wrote in message
...
Cells B1:D1 have a date format: Jan-05, Feb-05, Mar-05 (mmm-yy). If
the
month
is the current month, I would like to have that month and the four
cells
immediately below that month highlighed. For example, since March is
the
current month, I would like cells D1:D5 highlighted. The
highlighting
would
roll automatically based on the current month.

Thanks,
--
Howard

Howard

Bob, Thanks again!
I guess I better put my glasses back on.

HF

"Bob Phillips" wrote:

If you select B1:D5 as I originally stated, it will apply to al cells, and
so the 4 below are formatted as well

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Howard" wrote in message
...
Thanks!
Yes, it has a real date (mmm-yy). That did highlight the current month.
Is
there a way to have the four cells immediately below the cell with the
current month also highlighted? Those cells would have numbers.

Howard

"Bob Phillips" wrote:

BTW, I assume that B1:D1 have a real date, not just text. If it is text,
try
a formula of

=PROPER(LEFT(B$1,3))=TEXT(TODAY(),"mmm")


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bob Phillips" wrote in message
...
Use conditional formatting

Select B1:D5
FormatConditional Formatting
Change Condition1 to Formula Is
Add a formula of =MONTH(B$1)=MONTH(TODAY())
Click Format
Select the pattern tab
Select a colour

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Howard" wrote in message
...
Cells B1:D1 have a date format: Jan-05, Feb-05, Mar-05 (mmm-yy). If
the
month
is the current month, I would like to have that month and the four
cells
immediately below that month highlighed. For example, since March is
the
current month, I would like cells D1:D5 highlighted. The
highlighting
would
roll automatically based on the current month.

Thanks,
--
Howard

Howard