Highlight a cell if it changes as a result of formula recalculatio

G

Guest

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.
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
Highlight the cells referenced in the active cell formula 2
conditional format -- if not a date, then highlight cell 1
Extracting a Part of a Formula as Text 5
Can a formula do this? 1
Excel If a Cell Contains a Certain Text (From Another Table) 0
Function to Check if Cell is Highlighted for Change in Shared Work 2
Excel 2003 Conditional formatting not behaving as expected 0

Top