Skip to Content
Communication Square LLC Help Center

How to highlight row and column when user click on cell

How to highlight row and column when user click on cell

Written October 2022. Microsoft changes these admin screens often, so the screenshots below may not match what you see today. The sequence of steps is usually still correct — if something looks wrong, tell us and we'll update it.

  • 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/

Last updated on

Related articles