Sorting by colors on Numbers
How do I sort my spreadsheet by colors on Numbers? Please advise.
MacBook Pro 13", macOS 10.14
Apple Intelligence now features Image Playground, Genmoji, Writing Tools enhancements, seamless support for ChatGPT, and visual intelligence.
Apple Intelligence has also begun language expansion with localized English support for Australia, Canada, Ireland, New Zealand, South Africa, and the U.K. Learn more >
Apple Intelligence has also begun language expansion with localized English support for Australia, Canada, Ireland, New Zealand, South Africa, and the U.K. Learn more >
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.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
How do I sort my spreadsheet by colors on Numbers? Please advise.
MacBook Pro 13", macOS 10.14
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
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
You can export your Numbers spreadsheet to Excel, sort on colors, do what you need to do, then import back into Numbers. Whether or not it makes sense for you to do that depends on what you are trying to accomplish.
Sorting by colors on Numbers