How to identify "found" excel cells

%3CLINGO-SUB%20id%3D%22lingo-sub-1960952%22%20slang%3D%22en-US%22%3EHow%20to%20identify%20%22found%22%20excel%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1960952%22%20slang%3D%22en-US%22%3E%3CP%3EAfter%20searching%20for%20excel%20cells%20using%20Find%2C%20I%20have%20trouble%20locating%20the%20cells%20that%20have%20been%20found.%26nbsp%3B%20Is%20there%20a%20way%20to%20%22tell%22%20Find%20that%20I%20want%20the%20%22found%22%20cells%20highlighted%20by%20border%20or%20color%20so%20they%20are%20easier%20to%20locate%20after%20the%20search%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1960952%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1960993%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20identify%20%22found%22%20excel%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1960993%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F892833%22%20target%3D%22_blank%22%3E%40mitsu0F4U109%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20believe%20you%20could%20use%20replace.%20Replace%20it%20with%20the%20same%20text%2C%20but%20with%20a%20different%20format.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESay%20I%20wanted%20to%20search%20for%20cells%20containing%20%22a%22.%20So%2C%20I%20replace%20it%20with%20%22a%22%20and%20a%20yellow%20fill%20color.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

After searching for excel cells using Find, I have trouble locating the cells that have been found.  Is there a way to "tell" Find that I want the "found" cells highlighted by border or color so they are easier to locate after the search?

1 Reply

@mitsu0F4U109 

 

I believe you could use replace. Replace it with the same text, but with a different format.

 

Say I wanted to search for cells containing "a". So, I replace it with "a" and a yellow fill color.