Excel 2007 : To highlight active row and column

[r1jender]

Hi

Please provide me the code to highlight the active row and column without losing the current formatting.

Thanks
Rajender

[nmhung49]

Try

Please Login or Register  to view this content.

[royUK]

Here's one that highlights the row, could be adapted to highlight the column as well

[r1jender]

Hi.. the above solutions doesn't solve my problem, I want the code to highlight the active row and column, without losing the current formatting, pls help.

[dilipandey]

Hi r1jender,

By saying "highlight the active row and column" do you mean:-

1) to highlight the active row and column by some color
or
2) to highlight the active row and column by selection
or
some other mean?

Please clarify to enable forum to understand the query properly. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[royUK]

My example only colours cells that are not already formatted with a background colour & restores the original.