I'm glad it helped and had you asked for formula then that is doable.
However, before I try I'm nervous about

when I typed over
any given formula

Is this different than any formula?

Mike

"TamIam" wrote:

Thanks Mike! It worked, however, because I have inserted formulas throughout
the spreadsheet, I only really wanted it to change color when I typed over
any given formula. This is probably not possible, but I appreciate your
response, thanks again!
--
Thanks for your help!


"Mike H" wrote:

Try this,

Public OldRng As Range

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not OldRng Is Nothing Then
OldRng.Interior.ColorIndex = 35 'Awful green, change to taste
If OldRng.Value = "" Then OldRng.Interior.ColorIndex = xlNone
End If
Set OldRng = Target
End Sub

Right click the sheet tab, view code and paste in.

Mike


"TamIam" wrote:

Good day,

I don't know if this is possible in Excel, but I would like to change the
background color of a cell as soon as it has been typed in. Is this even
possible?
--
Thanks for your help!