Dave,

You need to use an event.

Copy the code below, right-click your sheet tab, select "View Code" and paste the code into the
window that appears.

This code will make cells with formulas that have been over-written bold and red.

HTH,
Bernie
MS Excel MVP

Private Sub Worksheet_Change(ByVal Target As Range)
Dim NewVal As Variant
With Application
.EnableEvents = False
NewVal = Target.Value
.Undo
If Target.HasFormula Then
Target.Font.Bold = True
Target.Font.ColorIndex = 3
End If
Target.Value = NewVal
.EnableEvents = True
End With
End Sub

"Dave" wrote in message
...
Hi All,

Hopefully this is a nice easy one that somebody can help me out with :-)

I have a column of data with formula's in (forecasted sales) during the
month I over key these when the actual orders come in. Is there a way that I
can set something up so that when I over key the formula the text changes in
some way either a different colour or bold for example. I have tried using
conditional formatting but don't seem to be getting anywhere.

Thanks in advance for your help

Regards

Dave