Thread: Find Feature
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default 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