Find Feature

N

NicoleS

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
 
T

Teethless mama

Select your range > Ctrl+H > Find what: enter your citeria > Replace with:
 
N

NicoleS

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?
 
Top