Eternal731
Board Regular
- Joined
- Jun 16, 2009
- Messages
- 55
Hello all,
I have been looking around for awhile, and have not been able to find a way to do this.
Basically I am trying to figure out a way to change the color of a cell if the original value changes, as if to say this cell has been updated/changed.
Scenario, im creating 2010 budget form worksheets for Regional Managers, each have multiple stores. Budget items will be listed A:A (100 or so), months Jan-Dec in the column headers, one worksheet for each store.
My plan was to overlay the prior years actual expenses and income as a starting point or guideline, then when a cell was changed/updated it would change the color or the cell to indicate that, that particular item has been accounted for.
Any alternate ideas would be great or a solution to the color changing thing. I'd post an example except I don't know how to tag it in the post. Thanks in advance
I have been looking around for awhile, and have not been able to find a way to do this.
Basically I am trying to figure out a way to change the color of a cell if the original value changes, as if to say this cell has been updated/changed.
Scenario, im creating 2010 budget form worksheets for Regional Managers, each have multiple stores. Budget items will be listed A:A (100 or so), months Jan-Dec in the column headers, one worksheet for each store.
My plan was to overlay the prior years actual expenses and income as a starting point or guideline, then when a cell was changed/updated it would change the color or the cell to indicate that, that particular item has been accounted for.
Any alternate ideas would be great or a solution to the color changing thing. I'd post an example except I don't know how to tag it in the post. Thanks in advance