Forum Discussion
Highlight a cell only when selected
Running Excel 365. Is there a way to highlight only the cell that is selected? When editing, have each cell highlight only when that cell is selected. All the cells seem to run together and makes it ...
gtfoster Yes, possible. You need VBA macro to do that. Use below macro.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.ScreenUpdating = False
Cells.Interior.ColorIndex = 0
Target.Interior.ColorIndex = 8
Application.ScreenUpdating = True
End Sub