Thread: Change color
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Change color

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!