You may want to try Chip Pearson's utility:
http://www.cpearson.com/excel/RowLiner.htm
Be aware that with this (and most macros), you lose the ability to do Edit|Undo.
Andrew wrote:
How do you change the default colour that excel applies to a selected range
of cells? I do not want to permenantly highlight them (fill them) but I do
want the selected range to be more obvious?
--
Dave Peterson