Color related cells when hovering above

[BramGrey]

Good day,

I have a table with several names of drivers under each other (imagine from A1 till A100). Next to that a table with on the top the days of the wee, and every drivers name on a specific day (example attached).

Is there a possibility when I hover over a name on the left side (if possible over every name of the driver, also on the calendar), this and all other cells on the page, colours in the same colour, so just by hovering over it. Just to make it clear when who is driving

EXAMPLE attached.
So when I hover over "Anita", on the right side all cells which contain "Anita" will light up.

Thanks!

 

[Herakles]

There is not a cell hover event but have a look at this here.

You could use the Worksheet_SelectionChange event to run code when you select the call with the name in it.
Write the name in the cell selected to another cell and use conditional formatting.

 

[BramGrey]

Thanks for the swift reply!

 

[shinigamilight]

You can instead use the arrow keys to select the cell in column 1 and it will work
Double click the sheet in vba editor > select general and flip it to worksheet > on the right drop down menu select selection change and paste this

'Private Sub Worksheet_SelectionChange(ByVal Target As Range)
            
            Range("C1").CurrentRegion.ClearFormats

            If Intersect(Target, Range("A:A")) Is Nothing = False Then
            lr = Range("C1").CurrentRegion.Rows.Count
            lc = Range("C1").End(xlToRight).Column

                    For k = 2 To lr
                            For j = 3 To lc
                             If Cells(k, j).Value = Target.Value Then
                                Cells(k, j).Interior.Color = vbYellow
                            End If
                            Next j
                    Next k

            End If

'End Sub