How to realize Spotlight in MS-EXCEL

I have tried WPS (an Chinese app, similar to MS-EXCEL), and it provides an interesting and useful funtion named Spotlight, which shades the entire columns and rows of the selected range to help user spot the cells of the same cols and rows. I have to say it "super awesome function", especially when the spreadsheet is very large.

I tried to duplicate the function in MS-EXCEL but none of them is "perfect". After several tries, I found a promising path with still some problems to solve. The path I tried is to utilize conditionformating to change the interior color of cells that meets the conditions (sharing same col and rows of the selected range). But the problem is that excel only provide CELL formula to return the address(col or row) of the first  cell of a selected, and no formula to return the last cell. So it could only change the format of a single col or row but not the rows or cols of the whole selected range.

I know that VBA could do the job and I myself realized it in VBA, but it has an unacceptable drawback, unabling the Undo function. My experiments with VBA shows that any change attempts made by VBA would distroy the undo list...

So how would I realize the function in MS-EXCEL. (of course, I would be super glad to see that EXCEL developers introduce the function natively to the app, cause it won't be difficult but SUPER useful for users)