Highlight Cell on Cursor Movement

[hiteshkumar21483]

I want to do a arrangement for a file like this " wherever cursor moves in excel that particular cell will highlight with color and once it goes to some other cell that last highlighted cell will come as a ordinary cell"

Pls Help....

[Special-K]

Maybe base something on this:

http://www.extendoffice.com/document...nd-column.html

[hiteshkumar21483]

No.. this is highlighting Concern Row & Column but i need only highlight that particular active cell.

[sktneer]

Try this.....
Right Click on Sheet Tab --> View Code --> Paste the code given below in the code window --> Save your workbook as Excel Macro-Enabled Workbook.

Please Login or Register  to view this content.

Is this what you are trying to achieve?

[hiteshkumar21483]

Sir, it's very good code but it's removing the color of all the color filled cell.

[LJMetzger]

Hi,

Try the attached file. If you want, you can select a MASTER CELL that contains the color you want to use. If there is no MASTER CELL color, then the default ColorIndex (27 = bright yellow) will be used.

Lewis

Code follows from ThisWorkbook module:

Please Login or Register  to view this content.