how do i change the selected cells color

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When i select cells in exel 2007 i don´t see the color it´s almost withe can
it be changed ?
 
Put the following macro in worksheet code:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Interior.ColorIndex = xlNone
Target.Interior.ColorIndex = 6
End Sub
 
Back
Top