| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Cell Change
Is there any way to determine if a cell has changed? I can not figure out how
to create a base that would not move also. I have some real time quotes which change all the time, and I want to determine when the high price has changed and use conditional formating to highlight the fact that a new high was reached. thanks |
|
#2
|
|||
|
|||
|
One option might be to use the ToolsTrack Changes feature |:)
"Mike" wrote: Is there any way to determine if a cell has changed? I can not figure out how to create a base that would not move also. I have some real time quotes which change all the time, and I want to determine when the high price has changed and use conditional formating to highlight the fact that a new high was reached. thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change cell back color on click | Excel Discussion (Misc queries) | |||
| Color change in cell when > 49.99 | Excel Discussion (Misc queries) | |||
| how do i copy formula and change worksheet instead of cell | Excel Worksheet Functions | |||
| Change workbook sheet reference using cell A1 to change a vairable | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
