Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to reference a column heading in a cell automatically? KenV Excel Worksheet Functions 5 December 14th 06 04:05 AM
In a table produce an value by column heading and row heading naflan Excel Worksheet Functions 1 December 27th 05 05:18 PM
How to extract just the Column Name of the active cell Fred Excel Discussion (Misc queries) 4 December 8th 05 06:24 PM
How to locate the Row and Column of an Active Cell Fred Excel Discussion (Misc queries) 1 December 7th 05 05:55 PM
how to display heading of column corresponding to the cell angelrain Excel Worksheet Functions 2 November 2nd 04 04:57 PM


All times are GMT +1. The time now is 03:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"