| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find/Replace but not exactly...
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! :) -- Thanks so much! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find/Replace but not exactly...
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 -- Gary's Student gsnu200707 "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! :) -- Thanks so much! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find/Replace but not exactly...
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. -- Thanks so much! "Gary''s Student" wrote: 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 -- Gary's Student gsnu200707 "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! :) -- Thanks so much! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! :) |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find/Replace but not exactly...
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. -- Thanks so much! "steph" wrote: 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. -- Thanks so much! "Gary''s Student" wrote: 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 -- Gary's Student gsnu200707 "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! :) -- Thanks so much! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| where to put results of find operation in find and replace functio | Excel Worksheet Functions | |||
| find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
| find and replace | Excel Discussion (Misc queries) | |||
| find replace cursor default to find box | Excel Discussion (Misc queries) | |||
| Find and Replace? | Excel Worksheet Functions | |||
Linear Mode
