Whats the simplist way of highlighting a change to a cell which is contains a different value to when it was last opened to indicate a new value (Change).
Ill explain :-
7 Workbooks in total being different departments.
1 Workbook being a status page containing totals and links to these others.
When this status one is opened if the link cells have changed in these other depts workbooks then a cell next to this link or the link cell itself formats to green background. If no change then it will stay say yellow.
Ill explain :-
7 Workbooks in total being different departments.
1 Workbook being a status page containing totals and links to these others.
When this status one is opened if the link cells have changed in these other depts workbooks then a cell next to this link or the link cell itself formats to green background. If no change then it will stay say yellow.