How to highlight row and column when user click on cell
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