I have a large sheet filled with part numbers. They can't be listed
sequentially as they are located under different supplier headings. I must
find the parts using the find (Ctrl-F). I'd like the found cell to be
highlighted automatically if possible. Please assist.
Mickey
Mickey Mouse - 02 Dec 2006 08:32 GMT
Sorry, missed a bit: I'm using Excel 2000
Mickey
>I have a large sheet filled with part numbers. They can't be listed
>sequentially as they are located under different supplier headings. I must
>find the parts using the find (Ctrl-F). I'd like the found cell to be
>highlighted automatically if possible. Please assist.
>
> Mickey
Hinojosa - 19 Dec 2006 14:34 GMT
Why don't use the replace format and use the same number but change the
format to highlight so if it finds it just hit replace and it will highlight
it...
>I have a large sheet filled with part numbers. They can't be listed
>sequentially as they are located under different supplier headings. I must
>find the parts using the find (Ctrl-F). I'd like the found cell to be
>highlighted automatically if possible. Please assist.
>
>Mickey