Color change
In general, that's quite a difficult thing to do (unless the changes
are only ever new records being added to the end of the data).
You would need to have a copy of the previous data, with which to
compare the new data. The new data might not be in the same sequence
as the previous data, rows might have been deleted etc.
If you can give a bit more information about the data, and the types of
change that will occur then we might be able to help further
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
|