how do i change the selected cells color

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When i select cells in exel 2007 i don´t see the color it´s almost withe can
it be changed ?
 
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

How can I change the cursor color in Excel? 1
Excel VBA 1
Excel VBA to move cells to sheet2 based on selection in sheet1 0
Exel 97 ColorIndex 1
How do I change the color for cell selection in excel? 8
in Excel: How do I change "selected cells" highlight color? 5
How to type each letter of the alphabet automatically in a specific color in Word? 0
change color of a range of cels in a row based on the value in one 3

Back
Top