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
Thank you!