Macro code to highlight each row when you click on them

Hi, can anyone advise me of the macro code required to highlight a complete row (say yellow) when you click in any cell in that row and to change back to normal colour when you click off the row

Any help would be greatly appreciated

Many thanks in advance


Rob

N.B. Excel version 2003

look at attachment

tom1977

EXCELLENT !! Just What I wanted

Many thanks

Rob