Get the access databaseto capture date and time of entry. Then on excel
format all changes beyond a date to show color of your choice. This should
not be too difficult.
"Bill Manville" wrote in message
...
As I said at the start, what you are trying to do is very difficult if
the set of records changes from one run to the next (with deletions and
additions).

If your records have a unique key in column A and your previous query
results are in sheet Week2 then you could use a conditional format
based on the formula (created when the active cell is in row 2)
=ISNA(MATCH($A2,Week2!$A:$A,0))
that will highlight rows that are new.

A second conditional format could be used to detect fields that have
changed in records that are common to new and old queries:
=A2<VLOOKUP($A2,Week2!$A:$AF,COLUMN(),FALSE)

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup