Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find Feature
Hello,
I like the find feature, but sometimes I can't tell where the found item is. Is there a way to set options so that when the text is located, the box can be highlighted a certain color? Thanks. NicoleS |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find Feature
Select your range Ctrl+H Find what: enter your citeria Replace with:
<leave it blank on the right hand side select Format Format Patterns tab select any color you like OK out "NicoleS" wrote: Hello, I like the find feature, but sometimes I can't tell where the found item is. Is there a way to set options so that when the text is located, the box can be highlighted a certain color? Thanks. NicoleS |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find Feature
I hit a send button to soon.
The last part is "selct all" "Teethless mama" wrote: Select your range Ctrl+H Find what: enter your citeria Replace with: <leave it blank on the right hand side select Format Format Patterns tab select any color you like OK out "NicoleS" wrote: Hello, I like the find feature, but sometimes I can't tell where the found item is. Is there a way to set options so that when the text is located, the box can be highlighted a certain color? Thanks. NicoleS |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find Feature
Thanks Teethless Mama,
a follow up question... When I do that, I get a message that Microsoft Office can't find the data... but I was testing it with a phrase I could see. I tested it twice, once selecting the whole sheet using the little box in the upper left column, and the other time by highlighting the whole sheet. Ideas? "Teethless mama" wrote: I hit a send button to soon. The last part is "selct all" "Teethless mama" wrote: Select your range Ctrl+H Find what: enter your citeria Replace with: <leave it blank on the right hand side select Format Format Patterns tab select any color you like OK out "NicoleS" wrote: Hello, I like the find feature, but sometimes I can't tell where the found item is. Is there a way to set options so that when the text is located, the box can be highlighted a certain color? Thanks. NicoleS |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find feature | Excel Discussion (Misc queries) | |||
Find Feature and Paste Link | Excel Discussion (Misc queries) | |||
Find Feature with Macro | Excel Worksheet Functions | |||
where can I find the Auto Sum feature on Excel | Excel Worksheet Functions | |||
how to change "Find" feature | Excel Worksheet Functions |