Use the following steps to highlight active row and column automatically. Step 1: Select the Data Range and click on "Conditional Formatting". Step 2: Click on "New Rules" and select "Use formula to determine which cells to format". Step 3: Write the formula in the box: =CELL("row")=ROW() Step 4: Repeat Step 1,2,3 and Add this formula in Step 3: =CELL("col")=COLUMN() Step 5: Right Click on the worksheet name and click on "View Code" Step 6: Select worksheet from the dropdown and then Write "Acti