Coloring the row and column numbering bars in Exce2003
 

I have a fairly large Excel work sheet and I need to traverse back and forth
as well as up and down frequently. So I need to keep track of the row and /
or column which I am traversing, lest I return to some wrong row or column.
It would be, therefore, very helpful if there is an highlighting on the row
and column numbering bars with a bright color, to help me note down before
traversing and return to the correct row / column, should I stray out. Is
there a method in Excel (Excel 2003) for achieving this?
Also presently I seem to have some such coloring scheme, but the color is
very close to the background colors of these bars, and I miss them many
times. Is there a way to change such a highlighting color as per my choice,
to get a good contrast and get my attenetion readily?
Thanks for all who would provide me suitable answers.

Coloring the row and column numbering bars in Exce2003
 

Try this in a sheet module.

Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Dim x1None As Boolean
Cells.Interior.ColorIndex = x1None
With ActiveCell
.EntireRow.Interior.ColorIndex = 35
.EntireColumn.Interior.ColorIndex = 35
End With
End Sub

If you have other cells colored within the sheet, it blows them away. Seems
there is a way around that but I do not have that solution at hand.

HTH
Regards,
Howard

"arasan77" wrote in message
...
I have a fairly large Excel work sheet and I need to traverse back and
forth
as well as up and down frequently. So I need to keep track of the row and
/
or column which I am traversing, lest I return to some wrong row or
column.
It would be, therefore, very helpful if there is an highlighting on the
row
and column numbering bars with a bright color, to help me note down before
traversing and return to the correct row / column, should I stray out. Is
there a method in Excel (Excel 2003) for achieving this?
Also presently I seem to have some such coloring scheme, but the color is
very close to the background colors of these bars, and I miss them many
times. Is there a way to change such a highlighting color as per my
choice,
to get a good contrast and get my attenetion readily?
Thanks for all who would provide me suitable answers.

Coloring the row and column numbering bars in Exce2003
 

I may entirely miss the point here, but isn't the best way of knowing which
row or column you are in, to use the clomn header or row title?

In other words, as a very simplified example, you may have three columns per
month, giving 36 for the year, say from Col B:AK, and 100 lines of data, say
from Row 3 to 102.
In row 1 and 2 you may have column headers. Row one the names of the
months, and row 2 say Budget, Actual and Variance.
In Col a, from row 3 down, you may have various Line titles, such as say
Bank, Bookkeeper, Capital, and so on.

If you then select cell B3, and click on View, Freeze panes, these headers
will always be visible. Sitting in Row 95, Col AB, you will see September,
and under that Actual, in rows 1 and 2. You would not even have to make a
note? On the left you will see exactly which cost unit you are working with
in Col A, so again no reason to make a note?

--
HTH

Kassie

Replace xxx with hotmail


"arasan77" wrote:

I have a fairly large Excel work sheet and I need to traverse back and forth
as well as up and down frequently. So I need to keep track of the row and /
or column which I am traversing, lest I return to some wrong row or column.
It would be, therefore, very helpful if there is an highlighting on the row
and column numbering bars with a bright color, to help me note down before
traversing and return to the correct row / column, should I stray out. Is
there a method in Excel (Excel 2003) for achieving this?
Also presently I seem to have some such coloring scheme, but the color is
very close to the background colors of these bars, and I miss them many
times. Is there a way to change such a highlighting color as per my choice,
to get a good contrast and get my attenetion readily?
Thanks for all who would provide me suitable answers.