Insert the following procedure into ThisWorkbook code:

'--------------------------------------------------
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Target.Characters.Font.ColorIndex = 3
End Sub
'--------------------------------------------------

HTH
--
AP


"Dave-Excel" a
écrit dans le message de
...

Freind of mine uses this forum a fair bit, comes highly reccomended :)

Anyway, could do with a little help.....

I have a spreadsheet with multiple data types across the entire
worksheet (Currancy, Data and Text). Now, im sending this to a data
editor for review and I need to know......

If anything is changed from the original file I sent, is there a way
Excel automatically changes the font color to red without any input
from the editor?

Thanks for any help guys.

Dave


--
Dave-Excel
------------------------------------------------------------------------
Dave-Excel's Profile:
http://www.excelforum.com/member.php...o&userid=32066
View this thread: http://www.excelforum.com/showthread...hreadid=518158