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