Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight upon change
Can u write a code to highlight a cell with any color if its value is
changed. Actually I am working at a Head Office and am collecting data from branches on a sheet that I am distributing however I have to keep a check if the original values have not been changed. Please consider the example: Action 1: Cell A1 has a value "5" if someone turns it to "6" the cell turns to Red. Action 2: Upon a realizing that he has made a mistake if he turns it back to "5" the cell is no longer highlighted. If it even doesn't work the second time, that is reverting back to non-highlighted, even a code for only the first action would also be higly obliged. Thanx! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i change the color of the GUI highlight area? | Excel Discussion (Misc queries) | |||
Any way to highlight cells that change? | New Users to Excel | |||
Change highlight cell color | Excel Discussion (Misc queries) | |||
Highlight entire document and try to change font - won't change. | Excel Discussion (Misc queries) | |||
change cursor to highlight cell I'm in | Excel Worksheet Functions |