Hi there
first, i apologize for the ambiguous title, i did not know how to best describe what i would like to do.
Essentially, in excel when you have a specific cell selected the x and y headings will be highlighted. What i would like to do is when i have a specific cell selected i would like to see all cells on its left and on top of it high lighted so that it pin points the spcific cell. and i would like that highlight to follow my selection around, so that it is not static?
so the original view is like this
original view.JPG
and then the modified may look something like this, where i added in the yellow highlights to show the "cross hairs" that i would like to see to pin point the cell i select.
modified view.JPG
would anyone know how i might be able to do this?
thanks for the help
SK
Bookmarks