how do i change the selected cells color

A

Asofio

When i select cells in exel 2007 i don´t see the color it´s almost withe can
it be changed ?
 
G

Gary''s Student

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
 
Top