You don't need a macro, use conditional formatting.

Select the cells, and use a formula of
=AND(B2<TODAY()-14,B2=TODAY()-29)

and set a pattern colour

--

HTH

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


"mauddib13" wrote
in message ...

I am trying to create a macro that will go through col. B and highlight
anything 14-29 days old in Yellow, and anything 29 days or older in
red. Can Anyone suggest a macro for me? I have created a formula to do
so but when I try to copy data from a PCOM session and paste the data
into the spreedsheet the formula does not work. I have to manually
reenter date for the highlighting to work. Any Help would be
appreciated on this one.


--
mauddib13
------------------------------------------------------------------------
mauddib13's Profile:
http://www.excelforum.com/member.php...o&userid=25785
View this thread: http://www.excelforum.com/showthread...hreadid=391908