You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Sorting by colors on Numbers

How do I sort my spreadsheet by colors on Numbers? Please advise.

MacBook Pro 13", macOS 10.14

Posted on Apr 26, 2019 3:52 PM

Reply
Question marked as Top-ranking reply

Posted on Apr 26, 2019 4:20 PM

Colour, whether applied to text or as color fill in cells, is a format, Numbers will sort only on the content of cels in the column chosen as the sort key.


You could number cells, or enter the colour names, in one column to match the associated colour of that row, then sort on the numbered column.


Regards,

Barry

2 replies
Question marked as Top-ranking reply

Apr 26, 2019 4:20 PM in response to jonplopez

Colour, whether applied to text or as color fill in cells, is a format, Numbers will sort only on the content of cels in the column chosen as the sort key.


You could number cells, or enter the colour names, in one column to match the associated colour of that row, then sort on the numbered column.


Regards,

Barry

Sorting by colors on Numbers

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.