how to get a cell highlighted with a particular color when it is selected?

when i click on a cell it should be highlighted with color yellow? while doing this the preexisting color should not go when we change the mouse. there are numerous suggestions in various places. but that vba when i added to the excel file does not show in the macro list. i am not able to save it to my personal excel workbook. how can it be accomplished.

see this macro

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time in the interests of moving things along. --6StringJazzer

This code is an event code recorded in the sheet' code
To see it you have to right clic the tab where it is recorded and select View Code

You could put this code in the ThisWorkbook module of your PersonalMacroWorkbook.

Please Login or Register  to view this content.

[QUOTE=mikerickson;4947481]
works fine. thank you.
But as per the code,when i format a cell (eg.D5)background as lightblue and then i move to another cell (eg.F6)the format already done in D5 cell goes. it should not happen. could you pls edit the code ?

No. I don't know how to do that.