Maybe...
You could use a worksheet_change event that looks for changes to your
worksheet. But you can fool this just by selecting a cell, hitting F2 and then
enter. Excel knows you reentered the value, but doesn't know that you didn't
really change it.
If you want to try...
rightclick on the worksheet tab that should have this behavior and select view
code. Then paste this into the code window that just opened.
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
Target.Font.ColorIndex = 3
End Sub
One more question. When do you want to reset your cells back to black. If I
were doing something like this, I do that part manually--then I could keep the
font red for as long as I needed.
And remember that if you have cells that are Blue, this'll change 'em to Red.
