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:
Bookmark to:
no comment