Currently in Excel 2000 when a cell is selected the Ros number and Column
letter are bolded to indicate location. Is there a way to have the entire
row and column shade to a light grey or other color to the point of
intersection?

ZABU

Better than that assuming that you are not using colored borders
would be Chip Pearson's Row liner
http://www.cpearson.com/excel/topic.htm
http://www.cpearson.com/excel/RowLiner.htm
of course if you want the one closer to what you asked you could
use the old one and it would still work:
http://www.cpearson.com/excel/excelM...ightActiveCell

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"ZABU" wrote in message ...
Currently in Excel 2000 when a cell is selected the Ros number and Column
letter are bolded to indicate location. Is there a way to have the entire
row and column shade to a light grey or other color to the point of
intersection?

ZABU

This has been solved by Chip Pearson.

Look at http://www.cpearson.com/excel/RowLiner.htm for the solution

--
Message posted from http://www.ExcelForum.com

Hi ZABU,

Thank you for posting in MSDN managed newsgroup!

The suggestion from David and Kieran will help you a lot in this issue.

If you have any further questions, please feel free to let me know.

Thank you for using Microsoft NewsGroup!

Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.