Open spreadsheet
ALT + F11
Insert > Module
Paste the following as a function
Function GetColor(MyCell As Range) GetColor = MyCell.Interior.ColorIndex End Function
Done. Now call the function using =GetColor(cellref)
then sort that column
Bookmark to:
