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