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

Changing Color of the Cell under Certain Conditions 8
why can't I change the color of a cell? 6
How to Color a Cell Based on a Range of Cells with Colors 1
How do I change highlight color of selected cells 2
CF to Color-Fill Row B:G w/Specific Text in One of the Cells 1
Find cells w/background color based on conditional formatting 2
Changing the default highllight for selected cells? 3
Changing color of selected cells in Excel 2007 1

Top