Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,856
Default i want to highlight entire row when selecting a cell in that r

I don't think so, but you could adjust the weight of the horizontal
lines to 3.0 for a very thick line.

Hope this helps.

Pete

On Dec 8, 9:46 pm, Dino wrote:
Pete, thanks. That works somewhat like I want. I had some problems
downloading Rowliner. It said something about signed certificates or I needed
to downgrade security on macros. But, when i opened Excel, it was there. Is
there a way to highlight the row with color instead of outlines? Again,
thanks for your knowledge. ....Dino



"Pete_UK" wrote:
Chip Pearson has a RowLiner addin he


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


This does something similar to what you want.


Hope this helps.


Pete


On Dec 7, 4:07 am, Dino wrote:
I have column 1 consisting of about 3000 stock numbers. Columns 2. 3, and 4
have related information pertaining to those stock numbers in column 1. Using
the "find" feature, I "zero in" on a certain stock number and then have
access to the related info. I want, when the particular stock number is
found, for that entire row to be highlighted so I can retrieve that
information more easily. I am using Excel 2003. Thanks in advance.- Hide quoted text -


- Show quoted text -


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35
Default i want to highlight entire row when selecting a cell in that r

Pete, that's what I thought and I accomplished what I wanted by applying a
bold dashed red liner to the row. It really stands out. Thanks for your
help....Dino

"Pete_UK" wrote:

I don't think so, but you could adjust the weight of the horizontal
lines to 3.0 for a very thick line.

Hope this helps.

Pete

On Dec 8, 9:46 pm, Dino wrote:
Pete, thanks. That works somewhat like I want. I had some problems
downloading Rowliner. It said something about signed certificates or I needed
to downgrade security on macros. But, when i opened Excel, it was there. Is
there a way to highlight the row with color instead of outlines? Again,
thanks for your knowledge. ....Dino



"Pete_UK" wrote:
Chip Pearson has a RowLiner addin he


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


This does something similar to what you want.


Hope this helps.


Pete


On Dec 7, 4:07 am, Dino wrote:
I have column 1 consisting of about 3000 stock numbers. Columns 2. 3, and 4
have related information pertaining to those stock numbers in column 1. Using
the "find" feature, I "zero in" on a certain stock number and then have
access to the related info. I want, when the particular stock number is
found, for that entire row to be highlighted so I can retrieve that
information more easily. I am using Excel 2003. Thanks in advance.- Hide quoted text -


- Show quoted text -



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,856
Default i want to highlight entire row when selecting a cell in that r

You're welcome - glad you sorted it out.

Pete

On Dec 9, 2:12 am, Dino wrote:
Pete, that's what I thought and I accomplished what I wanted by applying a
bold dashed red liner to the row. It really stands out. Thanks for your
help....Dino



"Pete_UK" wrote:
I don't think so, but you could adjust the weight of the horizontal
lines to 3.0 for a very thick line.


Hope this helps.


Pete


On Dec 8, 9:46 pm, Dino wrote:
Pete, thanks. That works somewhat like I want. I had some problems
downloading Rowliner. It said something about signed certificates or I needed
to downgrade security on macros. But, when i opened Excel, it was there. Is
there a way to highlight the row with color instead of outlines? Again,
thanks for your knowledge. ....Dino


"Pete_UK" wrote:
Chip Pearson has a RowLiner addin he


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


This does something similar to what you want.


Hope this helps.


Pete


On Dec 7, 4:07 am, Dino wrote:
I have column 1 consisting of about 3000 stock numbers. Columns 2. 3, and 4
have related information pertaining to those stock numbers in column 1. Using
the "find" feature, I "zero in" on a certain stock number and then have
access to the related info. I want, when the particular stock number is
found, for that entire row to be highlighted so I can retrieve that
information more easily. I am using Excel 2003. Thanks in advance.- Hide quoted text -


- Show quoted text -- Hide quoted text -


- Show quoted text -


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35
Default i want to highlight entire row when selecting a cell in that r

Is there a way to use the Add-in program "Rowliner" on a protected sheet? It
works when you unprotect sheet, but not when you protect it. Unfortunately,
some of my employees can't be trusted with unprotected sheets. But, we need
to use Rowliner, also. Thanks, what should I do?

"Pete_UK" wrote:

You're welcome - glad you sorted it out.

Pete

On Dec 9, 2:12 am, Dino wrote:
Pete, that's what I thought and I accomplished what I wanted by applying a
bold dashed red liner to the row. It really stands out. Thanks for your
help....Dino



"Pete_UK" wrote:
I don't think so, but you could adjust the weight of the horizontal
lines to 3.0 for a very thick line.


Hope this helps.


Pete


On Dec 8, 9:46 pm, Dino wrote:
Pete, thanks. That works somewhat like I want. I had some problems
downloading Rowliner. It said something about signed certificates or I needed
to downgrade security on macros. But, when i opened Excel, it was there. Is
there a way to highlight the row with color instead of outlines? Again,
thanks for your knowledge. ....Dino


"Pete_UK" wrote:
Chip Pearson has a RowLiner addin he


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


This does something similar to what you want.


Hope this helps.


Pete


On Dec 7, 4:07 am, Dino wrote:
I have column 1 consisting of about 3000 stock numbers. Columns 2. 3, and 4
have related information pertaining to those stock numbers in column 1. Using
the "find" feature, I "zero in" on a certain stock number and then have
access to the related info. I want, when the particular stock number is
found, for that entire row to be highlighted so I can retrieve that
information more easily. I am using Excel 2003. Thanks in advance.- Hide quoted text -


- Show quoted text -- Hide quoted text -


- Show quoted text -



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
When selecting cells in Excel 07 why doesn't it highlight? Andrea Excel Discussion (Misc queries) 1 November 6th 07 02:02 PM
Highlight the entire row or particular cell using conditional formatting vsr_kmb New Users to Excel 1 August 20th 06 11:05 AM
Can Excel automatically color highlight entire row of cell I'm in Estephanina Excel Discussion (Misc queries) 3 April 27th 06 09:54 PM
How do I get excell to highlight entire row when I am in any cell renah7 Excel Discussion (Misc queries) 2 November 23rd 05 03:19 PM
Moving cursor to another cell w/out selecting entire area Darin Excel Discussion (Misc queries) 8 May 13th 05 08:44 PM


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