Hi,
I realise you are making a suggestion to MS, but in the mean time, try
the below as a workaround...
Unless of course you already have a macro - as is suggested by the fact
that you could provide a screen dump showing this?

John McGimpsey provides a good macro on the below page (includes a link
to an addin of Chip Pearson's, also below). I think this is better than
the macro in Macropod's link as it allows for the old formatting to be
renewed once the active cell has moved.

http://www.mcgimpsey.com/excel/highl...iteRetainColor
http://www.cpearson.com/excel/RowLiner.htm

hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=533782