how do i change the selected cells color

A

Asofio

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

Gary''s Student

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
 

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

Fill tringle in a cell with color 1
Tracked changes by multiple people modified to one 0
Student & Home? 1
Need help modifying code 0
Layout Guide color 0
Word for Android background colors? (corrected) 0
Program buttons to create a word document 0
Select text of a particular shading color (VBA macro) 5

Top