automatic highlighting of row and column cell intersects

Giganews Newsgroups
Subject: automatic highlighting of row and column cell intersects
Posted by:  James (jboy…@magnaiv.com)
Date: Wed, 29 Oct 2003

I am trying to find out if it is possible to have Excel
automatically highlight(lightly shade) the row and column
of the active cell I am in.  That is if I am in cell H13,
then the whole row of 13 is highlighted and the complete
column of H is highlighted .  That way I can quickly see
all the information in row 13 quickly at a glance (i.e.
information in cell B13).

The highlighting would move accordingly to which ever
active cell I am in.  So as I move down then the subsequent
row would highlight.

Replies