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.