Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Highlight a cell if it changes as a result of formula recalculatio
Hi,
I am trying to create someything which will highlight a cell if it changes as result of another cell changing and therefor a formula recalculation. e.g. A B C 1 2 (A*B) I am looking for cell C1 to automatically highlight or change color if either cell a1 or a2 changes. -- Becky McGillycuddy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Highlight a cell if it changes as a result of formula recalculatio
You could use a sub worksheet_change(). This gets called for each cell that
get recalculated. If you change the 1 it will get highlighted as well as the data in column C. You probably under tool Menu - Track changes may do what you are looking for. "Becky" wrote: Hi, I am trying to create someything which will highlight a cell if it changes as result of another cell changing and therefor a formula recalculation. e.g. A B C 1 2 (A*B) I am looking for cell C1 to automatically highlight or change color if either cell a1 or a2 changes. -- Becky McGillycuddy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to highlight result of logical function | Excel Discussion (Misc queries) | |||
how do you highlight the result of an IF statement | Excel Worksheet Functions | |||
Formula Bar F9 Result differs from cell result??? | Excel Worksheet Functions | |||
Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
How do I highlight a formula result (IF statment=True) | Excel Worksheet Functions |