Maybe did't give you specific enough info.. I hoped it was as simple as
you typed.

But my workbook has over 700 rows. in column E between 1-700.000. all
the rows can change. What I want to see is that in column E, when a
value is changing, the cell turned red, so I can see which one has
changed.
Unfortunatelly it can't be done in your way.

Hope you've got something else...