ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   color banding in excel 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/185234-color-banding-excel-2007-a.html)

Janpan

color banding in excel 2007
 
When I click on a cell I would like it not only to hightlight that cell but
also the column and row up to their intersection point. I found a way to do
it in earlier versions of Excel but not 2007. Is there a way?

Gord Dibben

color banding in excel 2007
 
How did you do it in earlier versions?

Maybe you used Chip Pearson's RowLiner add-in?

http://www.cpearson.com/excel/RowLiner.htm


Gord Dibben MS Excel MVP


On Sat, 26 Apr 2008 07:53:01 -0700, Janpan
wrote:

When I click on a cell I would like it not only to hightlight that cell but
also the column and row up to their intersection point. I found a way to do
it in earlier versions of Excel but not 2007. Is there a way?




All times are GMT +1. The time now is 02:29 PM.

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