changing the way Excel displays selected cells
 

Is there a way to change the way Excel displays selected cells? I'm
interested in viewing all the selected cells highlighted (with light blue for
instance), but by default excel highlights all the cells but not the first one
the same occurs when you define a range with no adyacents cells

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