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