How to highlight row and column when user click on cell

Save workbook as macro enabled



Convert text to table



select all table except header



Conditional formatting, using formula  =COLUMN()=CELL("col")   then format



Again go to Conditional formatting by selecting all table except header, using formula

          =CELL("row")=ROW() then format as desire


Go to developer, visual basic, double click on your working sheet, click on general and choose worksheet. Write code as Application. Calculate


Close VBA, if not highlighting, you can use F9 to accelerate once.

Save and close

And enjoy

https://trumpexcel.com/highlight-active-row-column-excel/

Updated on: 31/01/2023