Your definition of the display is not quite correct.

Excel highlights the current cell, Excel also highlights a selected
range.

The currently selected cell is generally the first of a range, but
press enter and the current cell changes and becomes the second, then
third etc in the range.

You cannot have a cell not currently selected, which is what you are
indirectly asking for in your colour display.


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=390564