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: 19
Default Excel 2002; Macro for a light color band at the active row

Hi,

I find it difficult to read the cell content correctly at a distant column
of the same row.

For example to read the cell content of PQ 354 when the active cell is at
B354 when a large worksheet is open in a split window.

A B C D PQ PP
353 xxx T29
354 xxx K26
355 xxx U87

Is there any macro code for a light color band (light green or light yellow)
to turn on when I need it to serve as a "ruler" across an active row as I
move the cell up or down?

Appreciate very much if someone knowledgeable could help me on this.

Thanks

Low
 
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
Changing Band Format Color in Contour/Surface Map Dianna T Excel Discussion (Misc queries) 1 September 25th 09 05:36 PM
Excel 2002: Can I have a moving colored band for active row ? Mr. Low Excel Discussion (Misc queries) 1 August 5th 09 03:05 PM
How to replace the background color of all cells from light green to light blue? Claudia d'Amato Excel Discussion (Misc queries) 1 November 14th 08 07:09 PM
Excel 2002: How to conditional format band of colors ? Mr. Low Excel Discussion (Misc queries) 2 November 4th 08 01:45 PM
excel 2002 missing active title bar denisdasmenace Excel Discussion (Misc queries) 1 August 5th 08 04:32 PM


All times are GMT +1. The time now is 10:38 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"