Shade the current selected row - without using any VBA or macro code

[inddon]

Dear All,

I would like to have the following:
-Auto shading for the current row selected.

The above should be VBA and Macro code free.

I tried to look on the net, in vain. The solution comes in combination with VBA or macro codes, which I don't want as the workbook is macro and code disabled.

Looking forward for your help.

Regards
Don

 

[Faseeh]

Dear inddon

Vba in inevitable!!

 

[Bhawani]

Faseeh is right and also check attached file if it may be help you but your sheet need to recalculate every time.
Press F9 to see the result after changing active cell.
or you will to edit in cell.
Source is :-
http://www.tushar-mehta.com/publish... highlight row and col of selected cell.shtml

 

[inddon]

Faseeh is right and also check attached file if it may be help you but your sheet need to recalculate every time.
Press F9 to see the result after changing active cell.
or you will to edit in cell.
Source is :-
http://www.tushar-mehta.com/publish_train/xl_vba_cases/0121 highlight row and col of selected cell.shtml

Thank you Bhawani for your help and providing the link. I have included the code and it works perfect.

I hope MS will come up with a solution without writing any code.

Regards
Don

 

[Bhawani]

Okies and welcome back any time.