Macro - To change cell fonts whenever their values change

Data is entered progressively on new lines (down sheet 3), and the calculated results are displayed on sheet 1.


What macro, will:

• Change the fonts in D10:L18 (on sheet 1)…

. In only those cells (if any), whose values are changed by the most recent data entry.
. From Arial Regular black.
. To Arial Bold black.
. While ignoring the unchanged cells (D10:L18).


• Then, as more data is entered…

. Repeat the above.
. While reversing the previous font changes.



There is much Conditional Formatting in cells D10:L18


I’m using…

. Excel 2010
. Win7

mgs