Hi all,

I've got a large pricing spreadsheet that is currently being updated by
several users. When I get it back I need to be able to see what changes have
been made and to check whether formulas are still intact (not pasted over).

I didn't apply any worksheet change event code before hand but I did create
a copy of the original data and put on a tab called 'Save' (this is hidden) -
so I was wondering if there was any way of comparing the two worksheets and
highlighting any changes using the Save copy as a baseline??

This is what I need to check (and maybe highlight with a background fill
colour):

- that there were NO changes in columns A-O
- if column P was changed, then column Q must be populated
- U, Z, AF, AL, AR, AT must have intact formula.
- if column AT is 10% or <-10% turn font RED. Red values must have comment
entered in column BN so highlight empty BN cells if AT is red.

so... as you can see I have quite a challenge ahead of me!!
Can someone please let me know if this is even possible??

Thank you in advance! :-)