ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can I get the row and column heading of my active cell highlig (https://www.excelbanter.com/excel-discussion-misc-queries/135092-how-can-i-get-row-column-heading-my-active-cell-highlig.html)

SANCAKLI

How can I get the row and column heading of my active cell highlig
 
I am using an Excel 2000. Currently I have difficulty in identifying the row
and column headings of the active cell because the row and column headings of
the active cell have the same color as all other row and column headings.
I would like to know whether there is a way to show the row and column
headings of the active cell in ANOTHER color - different from all other row
and column headings.
Ex: Let's assume all my row and column headings are in gray color. If my
active cell is B5, then I want the column heading "B", and row heading "5" to
show a different color than gray, RED for instance.
thank you

Gord Dibben

How can I get the row and column heading of my active cell highlig
 
Excel uses the color scheme set in your Windows OS Display Properties.

If you make changes at that point, they will be global changes and affect all
Windows applications.


Gord Dibben MS Excel MVP

On Thu, 15 Mar 2007 15:58:02 -0700, SANCAKLI
wrote:

I am using an Excel 2000. Currently I have difficulty in identifying the row
and column headings of the active cell because the row and column headings of
the active cell have the same color as all other row and column headings.
I would like to know whether there is a way to show the row and column
headings of the active cell in ANOTHER color - different from all other row
and column headings.
Ex: Let's assume all my row and column headings are in gray color. If my
active cell is B5, then I want the column heading "B", and row heading "5" to
show a different color than gray, RED for instance.
thank you



SANCAKLI

How can I get the row and column heading of my active cell hig
 
that is exactly what I was afraid of actually. I have visited home last
weekend and my brother had a new laptop with Excel 2003 on it. On that laptop
the row and column headings of the active cell were clearly standing out
because they had a different color. Perhaps I should check what Display
properties he has on that lap top.
thank you very much anyway...


"Gord Dibben" wrote:

Excel uses the color scheme set in your Windows OS Display Properties.

If you make changes at that point, they will be global changes and affect all
Windows applications.


Gord Dibben MS Excel MVP

On Thu, 15 Mar 2007 15:58:02 -0700, SANCAKLI
wrote:

I am using an Excel 2000. Currently I have difficulty in identifying the row
and column headings of the active cell because the row and column headings of
the active cell have the same color as all other row and column headings.
I would like to know whether there is a way to show the row and column
headings of the active cell in ANOTHER color - different from all other row
and column headings.
Ex: Let's assume all my row and column headings are in gray color. If my
active cell is B5, then I want the column heading "B", and row heading "5" to
show a different color than gray, RED for instance.
thank you





All times are GMT +1. The time now is 08:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com