VBA: Script to change text color if a change is made

[hector.febus]

Hello,

I have this code (see below), the code changes new text entered to blue, but as soon as you click enter, the text in the cell is treated as old, so if you go again into the cell and make another change, it will change the text to black and only the new change to blue. I need it to continue changing to blue and keep recent changes in blue.

Please Login or Register  to view this content.