https://www.thesmallman.com/blog/2016/9/15/auto-highlight-the-active-row-when-a-cell-is-selected Highlighting rows with conditional formatting in itself is not difficult. It is the automatic part that is tricky. First, select all continuous data by selecting a cell in your data and using the shortcut ‘Ctrl + A’. In the project file, the selected range is A1:E55. Then, click the ‘Conditional Formatting’-button on the ‘Home’ tab in the ribbon. Click ‘New Rule’ and in the following dialog box choose ‘Use a formula to determine which cells to format’. In the formula field, enter this formula: =OR(CELL("row")=CELL("row",A1)) The last argument of the second ‘CELL’-function (the A1) must be the top left cell of the selected data (from before you clicked the ‘Conditional Formatting’ button). Writing The Macro I have written the macro for you, but it is not complicated. It simply looks like this: Option Explicit Private Sub Worksheet_SelectionChange(ByVal Target As Range) Target.Calculate End Sub This code goes not in a normal module, but in the code belonging to a specific worksheet. Use the shortcut ‘Alt + F11’ to get to the ‘VBA editor’. Double click ‘Sheet2(Employees)’ in the ‘Project Explorer’ and paste the code from above. If your ‘Project Explorer’ (the menu to the left) is missing and it does not look like the screenshot on your computer, you need to toggle on the ‘Project Explorer’. Click ‘View’ in the menu and click ‘Project Explorer’.