| deltreg
|
2274
|
 |
|
06-11-2009 04:44 PM BST
|
|
Ray You can identify changes when updating your spreadsheet by using conditional formatting. If you have a column/row with last weeks figures in and a column with this weeks figures in. Then choose this weeks cell, choose Format, Conditional formatting, choose Cell value is, not equal to,type last weeks cell ref. and in Format choose patterns and choose a colour. Copy formatting to other cells. These cells will automatically colour when value is different. As for email, pass.
|