Thread: how do i change the selected cells color
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default how do i change the selected cells color
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

--
Gary''s Student
gsnu200709


"Asofio" wrote:

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