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