Highlight cell upon selection

**m.cain** · 04-24-2012, 01:53 PM

Hello,

I would like a cell's fill colour to change upon selection. E.g., Clicking on the cell makes it grey. Clicking on it a second time makes it white again. (i.e., click cell, if current fill is white, set fill to grey, else set to fill to white).

I'd really appreciate your help. Thanks.

**m.cain** · 04-24-2012, 03:12 PM

Alternatively, if I were to mask the cell as a toggle button, where selecting the cell (i.e., button) would make it a default BackColor when the value is true, then that might be another option...

**rollis13** · 04-24-2012, 05:05 PM

You could try to work around something like this placed in the sheets code:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If ActiveCell.Interior.ColorIndex = 44 Then
        ActiveCell.Interior.ColorIndex = xlNone
    Else
        ActiveCell.Interior.ColorIndex = 44      '6=yellow  3=red 
    End If
    Cells.Borders.LineStyle = xlLineStyleNone
    ActiveCell.Borders.LineStyle = xlContinuous
End Sub