Highlighting cells whilst editing

[Guest]

Hello!

For all you Excel experts out there - is there any way to highlight a cell
that is currently being edited in different colours or for that matter
filling the background of the cell with a colour? Once you leave the cell it
should revert back to the standard colour being used in the spreadsheet, ie.
black font/white background.

This is to make a big spreadsheet easier to edit and to find where your
current position is in the spreadsheet easier.

Hope that makes sense.

Thanks in advance for your help.

 

[Paul B]

Loonia, see if this will help

http://www.cpearson.com/excel/excelM.htm#HighlightActiveCell

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003