Change the color of Selected Row, column or cells

  • Thread starter Thread starter Tracey
  • Start date Start date
T

Tracey

Basicly, If I can explain this right here is what I would like to be able to
do.

I have Excel 2007. When I use my mouse to select a range of cells lets just
say we are going to copy them to another area. What I would like to see is
where I just selected the cells they highlight a brighter color than that
normal gray/white color that indicates items selected. Is there a way to do
this? I am pretty sure I have seen it done before. I do not need to use any
conditional fromation. I just need it to be an option that I can turn on or
off and is able to change the color.

Thank You
Tracey
 
Put this event macro in the worksheet code area:

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

The disadvantage is that previous hi-lighting is fully erased.
 
Back
Top