Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
When selecting cells in Excel 07 why doesn't it highlight? | Excel Discussion (Misc queries) | |||
Highlight the entire row or particular cell using conditional formatting | New Users to Excel | |||
Can Excel automatically color highlight entire row of cell I'm in | Excel Discussion (Misc queries) | |||
How do I get excell to highlight entire row when I am in any cell | Excel Discussion (Misc queries) | |||
Moving cursor to another cell w/out selecting entire area | Excel Discussion (Misc queries) |