Is there a way to automatically highlight the column and the row that of the current
Is there a way to automatically highlight the column and the row of the current cell?
I’m wondering if there is a way to highlight the row and the column of the current cell.
For example, in the attached screenshots, I need a dynamic highlight for the row and the column of the current cell such that when the cell is changed then the column and the row of the new cell are highlighted.
The current behavior of the Excel is based on highlighting only the header of the column and the row of the current cell but what I need is to automatically highlight the entire column and row of the current cell.
Thank you in advance for the help
Best
Jamal
|