If you are doing by macro then you should be able to delete the prior
interiorcolor and color the new cells. If desired, send your file to my
address below and I'll take a look.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"tonydi" wrote in message
...
I'm using Excel 2007's built-in 'data from web' to pull in a table that is
sorted alphabetically. The content of the table gets updated with new info
added to the existing info so the table grows and nothing gets deleted.

I'd like to be able to automatically have whatever is new since the last
import be highlighted in some way so I can easily scan the spreadsheet and
find those new lines. I've tried all sorts of formatting for the existing
data but the new items inherit that formatting.

Any ideas on highlighting the changes? I don't care if I have to manually
un-do the highlighting for the next time the table gets updated, but just
being able to see the new stuff at the time of importing is the important
part.