SheetChange Event
 

Nothing needs to be added to that code. That will change the font color
of the changed cells. If it doesnt seem to be doing anything, try
closing excel and launching a new workbook, then retry the code.


--
crispbd
------------------------------------------------------------------------
crispbd's Profile: http://www.excelforum.com/member.php...o&userid=10880
View this thread: http://www.excelforum.com/showthread...hreadid=319826