highlights

Is there a way to highlight the row and column that intersect at a cell I click on?

Hi,

Do you mean something like this? This is done with VBA. There is no way to do this using regular Excel functions.

I hope this helps