Excel Formula to Group Similar Text by Color
Sohana Chowdhury
July 2, 2026
Grouping similar text by color visually organizes large and complex datasets. Although Excel doesn’t have a direct formula to group by color, you can combine formulas, filters, conditional formatting rules, and helper columns to achieve this easily. As a workaround, we’ll first apply conditional formatting rules to cells containing similar text. After that, we can use the SORTBY function to rearrange our dataset to group texts by color using those
