Customizing the Active Cursor Cell

[btkoenig7]

Thank you in advance. I am trying to help someone in my office who does a lot of manual data entry in excel. She is looking for a way to customize her excel so that her active cell is a difference color than the rest of the spreadsheet. Is there a way this can be done? We currently have Microsoft Office 365 Business.

Example: We would like the cursor button (typically just a black/green outline of the cell) to have a yellow fill color.

 

[Joe4]

Welcome to the Board!

Some people have already come up with some solutions. See if any work for you:
https://msdn.microsoft.com/en-us/vba/excel-vba/articles/highlight-the-active-cell-row-or-column
https://www.excel-easy.com/vba/examples/highlight-active-cell.html
https://www.extendoffice.com/documents/excel/2129-excel-highlight-active-cell.html

 

[MickG]

Try this:-
NB:- This code should change the selected cell colour to "Yellow", then change it back to previous colour when new cells is selected.

Option Explicit
Dim Rng As Range, col As Long
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Target.Count = 1 Then
        If Not Rng Is Nothing Then Rng.Interior.Color = col
        Set Rng = Target
        col = Rng.Interior.Color
        Rng.Interior.Color = vbYellow
    End If
End Sub