Find/Replace but not exactly...

S

steph

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! :)
 
S

steph

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.
 
G

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
 
S

steph

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.
 
Top