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.
