Highlight Active Row and Column in Excel (Based on Cell Selection)

[atthershabbir]

Hi
I work with data sets daily with different files, so need some code to Highlight Active Row and column in excel.
I found a code online which i hv pasted below and have created a Macro in my Personal workbook so i can use in any file.
So everytime a new Excel file is opened i run the Macro from Personal Workbook and the Rows n Columns are selected but as i change the cell i have to press F9 everytime. Is there any solution to that, so that as i move the cell the rows n columns r selected dynamically without pressing F9 everytime.
One more thing i dont want this feature on all the excel files i work, as other normal files i wont need this funtion... Hoping to get a reply.

Please Login or Register  to view this content.

[mehmetcik]

Hi.

What you are after are cross hairs.

You will need two conditional format rules and this code:

=AND(CELL("col")=CELL("col",A1),CELL("row")=CELL("row",A1)) for Yellow

=OR(CELL("col")=COLUMN(A1),CELL("row")=ROW(A1)) for Grey

Please Login or Register  to view this content.

[atthershabbir]

Thanks for your reply brother.. i got it and can be used in single file only..
is it even possible for this feature to work on Personal workbook?.
Your reply would be helpful.