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.
--
Gary''s Student - gsnu200832


"Tracey" wrote:

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