"Find all" missing in Mac version of Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1657114%22%20slang%3D%22en-US%22%3E%22Find%20all%22%20missing%20in%20Mac%20version%20of%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1657114%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20function%20is%20in%20the%20MS%20online%20version%20and%20the%20PC%20version%2C%20but%20strangely%20missing%20on%20Mac.%20The%20proposed%20solution%20is%20conditional%20highlighting%2C%20but%20this%20doesn't%20produce%20a%20list.%20I%20still%20have%20to%20scroll%20through%20the%20entire%20column%20to%20see%20each%20individual%20highlight.%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20workaround%20for%20this%20or%20a%20way%20to%20view%20all%20the%20cells%20matching%20the%20search%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1657114%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

This function is in the MS online version and the PC version, but strangely missing on Mac. The proposed solution is conditional highlighting, but this doesn't produce a list. I still have to scroll through the entire column to see each individual highlight. 

Is there a workaround for this or a way to view all the cells matching the search?

 

 

0 Replies