Highlight active cell and de-highlight previous cell

D

dmbuso

I want to highlight the current cell with a color say gray and set the color
of the last cell I was at back to what it currently was. The code below does
not work. It sets the previous cell color to white and if the cell color was
something other than white, say green, I lose the color green for the
previous cell.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
On Error Resume Next

Static OldRange As Range

'Set backcolor to whatever, change as needed
Target.Interior.ColorIndex = 15 'light gray

OldRange.Interior.ColorIndex = xlColorIndexNone
Set OldRange = Target

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

Highlight a cell after update in a specific range 2
Format / Highlight the Active Cell 1
Use BeforeDoubleClick to place 1 or 4 character in a cell 1
Highlighting The Active Cell 2
Highlight Selected Range Only 2
Change cell font color when cell is clicked 9
Conditional Formatting- Refresh 7
function work with manual update, fails with copy paste > 1 cell 4

Top