Change Highlight color of active cell

  • Thread starter Thread starter M. Burnett
  • Start date Start date
M

M. Burnett

I would like to be able to change the color of the active
cell. In a large spreadsheet this would help in
distinguishing it from other cells without looking at
the "bolded" row and column.

Any ideas?
 
Why not try the Conditional Formatting from the Format menu ?

Milind
 
Try this: In the declaration (upper right corner), choose
activate:

Private Sub Worksheet_SelectionChange(ByVal Target As
Range)
If Not OldRng Is Nothing Then
OldRng.Interior.ColorIndex = xlNone
End If
Target.Interior.ColorIndex = 6
Set OldRng = Target
End Sub
 
You must log in or register to reply here.

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

Excel Highlight active cell with font color? 3
Active Cell Color 5
Highlight Highest Amount 2
Excel VBA 1
How do I change the color of the indicator cell in row and column 1
Excel Highlighting duplicates 0
Active Cell Border Color 2
Highlighted cell color 1

Back
Top