That's Funny!!
I actually JUST wrote the exact same function about a week ago!! I was
afraid the user might forget they overwrote a cell..
Put this code in the worksheet_change event of the worksheet your data is in..
Private Sub Worksheet_Change(ByVal Target As Range)
' All this if does, is limit the color change to a specific region of the
worksheet
If ((Target.Column() 39) And (Target.Row() 1)) Then
If Target.HasFormula Then
Target.Interior.ColorIndex = xlNone
Else
Target.Interior.ColorIndex = 35
End If
End If
End Sub
"bell7526" wrote:
How do I get the cell to highlight or letters to change color when someone
changes the content in a cell. Example is I want to have a formula in a cell
that is a projection and if someone types a plain number over top it to
adjust the project I want it to highlight. so if the formula calculates 75
and they want 100 they just key it over the formula and the cell will
highlight that there was a change. Can someone help me?
--
Billy Bellamy
|