LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
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 02:12 PM.

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"