View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Find/Replace but not exactly...

steph

DataFilterAutofilter for"All GL Accounts"

Then F5SpecialVisible cells onlyOK

Format to Bold.

Remove the Filter.


Gord Dibben MS Excel MVP

On Thu, 22 Feb 2007 14:40:08 -0800, steph
wrote:

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