i want to highlight entire row when selecting a cell in that row

[Dino]

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.

 

[Pete_UK]

Chip Pearson has a RowLiner addin here:

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

This does something similar to what you want.

Hope this helps.

Pete

 

[Gord Dibben]

Have you thought about Data>Filter>Autofilter?


Gord Dibben MS Excel MVP

 

[Dino]

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

 

[Dino]

Gord, thanks, I thought about that and have used auto filter many times and
it is very useful, but in this case, 99% of the people accessing this file
will not be able to do that because of lack of Excel knowledge. I want it to
be automatic for them. To find the stock number and the information will be
clear as a bell to them. I'm the person who made the file and I want the
procedure to be easy for them.

 

[Gord Dibben]

OK.

How will they know which stock number to look for?

You could use some VLOOKUP formulas to return the info if the users were able to
type a stock number into a cell.

With your lookup table range of A13000 on sheet1.

In B2 of sheet2 enter

=IF(ISNA(VLOOKUP(A2, Sheet1!$A$1:$D$3000,2,FALSE)),"",VLOOKUP(A2,
Sheet1!$A$1:$D$3000,2,FALSE))

Copy across to D2 changing the column reference from 2 to 3 to 4

Enter a stock number in A2 and the info will appear in B2, C2, D2

You could if you wanted, provide a Data Validation dropdown list in A2 for users
to choose a stock number.


Gord

 

[Pete_UK]

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

 

[Dino]

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

 

[Dino]

Gord, They actually get the stock number from a different file while
receiving and processing airplane parts. They copy the stock number from a
particular screen and then toggle to the Excel program and use the "find"
feature and paste that stock number to it and Excel will then sort and find
that number on the list. Your formula looks interesting and it sounds like it
would make isolating the particular stock number automatic if they pasted the
stock number into A2. Right? Thanks for the information.......Dino

 

[Gord Dibben]

Yes

Paste the stock number into A2 and you will get info in B22 from the table on
sheet1

Gord

 

[Dino]

Thanks, I'll try it. That would eliminate worrying about highlighting a
particular row because the needed information would be by itself on the page.
Thanks again.

Dino

 

[Pete_UK]

You're welcome - glad you sorted it out.

Pete

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






- Show quoted text -

 

[Dino]

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?