Greetings, I haven't applied this to a spreadsheet, yet, but I have found an MS support page on Excel sorting by color.
https://support.microsoft.com/en-us/office/sort-data-in-a-range-or-table-62d0b95d-2a90-4610-a6ae-2e545c4a4654 On a quick skim, it appears the user MUST define a sort order that lies outside of text/numeric. Which makes sense, there's no one sort order that would fit all users. Complicated behavior though. Hope everyone is at the start of a great week! Patrick -- Patrick Durusau
patrick@durusau.net Technical Advisory Board, OASIS (TAB) Editor, OpenDocument Format TC (OASIS), Project Editor ISO/IEC 26300 Co-Editor, ISO/IEC 13250-1, 13250-5 (Topic Maps) Another Word For It (blog):
http://tm.durusau.net Homepage:
http://www.durusau.net Twitter: patrickDurusau