Highlight row with specific text and sort by color

%3CLINGO-SUB%20id%3D%22lingo-sub-1897331%22%20slang%3D%22en-US%22%3EHighlight%20row%20with%20specific%20text%20and%20sort%20by%20color%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1897331%22%20slang%3D%22en-US%22%3E%3CP%3EPlease%20need%20suggestion%20to%26nbsp%3BHighlight%20row%20with%20specific%20text%20and%20sort%20by%20color%20form%20a%20large%20file.%20thank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1897331%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1898998%22%20slang%3D%22en-US%22%3ERe%3A%20Highlight%20row%20with%20specific%20text%20and%20sort%20by%20color%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1898998%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F872245%22%20target%3D%22_blank%22%3E%40AyoAde710%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20below%20link%20might%20be%20helpful%20for%20you%20to%20highlight%20the%20row%20with%20a%20specific%20text%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fyoutu.be%2FKlj_69VibzM%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CSPAN%3Ehttps%3A%2F%2Fyoutu.be%2FKlj_69VibzM%3C%2FSPAN%3E%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20regards%20to%20sort%20by%20color%20you%20can%20apply%20filter%20and%20sort%20the%20same%20by%20color%20as%20you%20like%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eif%20it%20didn't%20meet%20what%20you%20need%2C%20request%20you%20to%20please%20attached%20sample%20file%20with%20your%20desired%20output.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%2FBest%20Answer%20%26amp%3B%20like%20it%20to%20help%20the%20other%20members%20find%20it%20more.%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Please need suggestion to Highlight row with specific text and sort by color form a large file. thank you

1 Reply
Highlighted

Hi @AyoAde710 

 

The below link might be helpful for you to highlight the row with a specific text  

https://youtu.be/Klj_69VibzM

 

With regards to sort by color you can apply filter and sort the same by color as you like 

 

if it didn't meet what you need, request you to please attached sample file with your desired output.

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official/Best Answer & like it to help the other members find it more.