fireslguk
04-09-2006, 03:35 AM
hi all, is it possible to have a cell change colour only when the cell content (which is a number) is different from when the workbook was last opened.
This cell is linked to another workbook and will always ascend in number.
Yes it will update when the workbook is opened with a new number if the other workbook was changed however i wanted something more visual to detect the change. e.g no change red background, cell changed = green, then when workbook closed reverts to red so you can see change next time round, hope clear
many thanks if any1 could help
This cell is linked to another workbook and will always ascend in number.
Yes it will update when the workbook is opened with a new number if the other workbook was changed however i wanted something more visual to detect the change. e.g no change red background, cell changed = green, then when workbook closed reverts to red so you can see change next time round, hope clear
many thanks if any1 could help