Change the color of Selected Row, column or cells

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
 
G

Gary''s Student

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help modifying code 0
Select text of a particular shading color (VBA macro) 5
Need Help with a VBA subroutine 0
Conditional formatting 2
Changing the color of rows - conditional formatting 3
How to Select Multiple Emails using Surface Pen 0
Change row colors based on a cell value 1
Changing Cell Color Based on Value 2

Top