looking for changes in worksheets or books
 

I get a weekly file (approx. 850 lines/records) and need to find changes in
data (dates and numbers) and line/record deletions and additions. It would
be nice to have those delta's for each line/record shown in a seperate
worksheet highlighted gray. Also need to indicate if a cells value is equal
to 1 and ighlight that line/record higlighted green.
--
mlong