Automatically turn text blue everytime a cell value is changed

[excelmyexcel]

Hi,

I am trying to have Excel automatically change black text to blue text everytime a user changes a value in a cell.

For example, if a cell contains "$1,201.45" in black text and a user changes it to "$559.38", the color of the text in that cell will automatically change to blue.

Any ideas appreciated. Thanks for your help.

 

[cornflakegirl]

Private Sub Worksheet_Change(ByVal Target As Range)
Target.Font.Color = vbBlue
End Sub

(Right click the sheet tab - View code - paste there)

 

[excelmyexcel]

cornflakegirl - thanks for your help!