Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight finding in Excel
Hi everyone,
As Excel can't highlight what you have found using 'Find', is there any other way to achieve this outcome? I used to copy and paste them to Word but now the data gets to large and my Pentium 4 computer can't cope! Thx |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight finding in Excel
If you are you looking for ONE item use FIND and then
Sub findandhilite() Columns(2).Find(1).Interior.ColorIndex = 3 End Sub if mor than one look at the example for FINDNEXT and use the same idea -- Don Guillett SalesAid Software "Rick .<" wrote in message ... Hi everyone, As Excel can't highlight what you have found using 'Find', is there any other way to achieve this outcome? I used to copy and paste them to Word but now the data gets to large and my Pentium 4 computer can't cope! Thx |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight finding in Excel
Have you tried conditional formatting?
I.e., if the thing you wan to find is all instances of 56, then you can set the conditional formatting to bold all cells with a value of 56, etc. "Rick .<" wrote: Hi everyone, As Excel can't highlight what you have found using 'Find', is there any other way to achieve this outcome? I used to copy and paste them to Word but now the data gets to large and my Pentium 4 computer can't cope! Thx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
I want to use a formula in excel to highlight a cell 30 days prio | Excel Worksheet Functions | |||
Finding and killing all Access queries in an Excel spreadsheet | Links and Linking in Excel |