Find/Replace but not exactly...

[Guest]

I have a .csv file that I've pasted into an EXCEL 2002 worksheet. In one
column, the string "All GL Accounts" appears in multiple cells. I need to
locate those cells and then BOLD the entire row where those cells are
located. Can someone tell me a reasonably simple way to do this without
visually searching through over 1400 rows? I hope so!

 

[Guest]

You can use Conditional Formatting to hi-light an entire row of cells based
on the value in one of the cells:

http://www.contextures.com/xlCondFormat02.html

 

[Guest]

It makes sense to use conditional formatting but I can't quite get it to
work. Maybe if i give you an example you could get me over the finish line...
In column E there is an alpha-numeric string "xxxxxx - title". The last
time that particular string is displayed, column F will display the string
"All GL Accounts".

col E col F
abcdef - title 123456
abcdef - title 123456
abcdef - title All GL Accounts
ghijkl - title 456789

I will need to highlight the entire 3rd row of the data above.
Hope this helps.

 

[Gord Dibben]

steph

Data>Filter>Autofilter for"All GL Accounts"

Then F5>Special>Visible cells only>OK

Format to Bold.

Remove the Filter.


Gord Dibben MS Excel MVP

 

[Guest]

Gary's student...I finally got the conditional formatting to work. I was
focused on using the "Cell Value Is" feature instead of the "Formula Is"
feature. Much appreciate the tip.