I have been tasked with creating a spreadsheet for my workplace that has multiple information on it, regarding cars, MOT date etc., IMO I have a decent spreadsheet working that will auto change colour based on the data that is in a certain cell.

However, I cannot figure out how I can auto sort the colours in a specific order, see link for example:


Any help would be much appreciated!

  • 1
    Welcome to Web Applications. The filter feature includes a "Sort by color" that allows to select one color of the used on the filter range. Please show what you tried and add more details about the specific order that you need.
    – Rubén
    Jun 15, 2022 at 0:22

1 Answer 1


If you create a filter, you should be able to "Sort by color" > "Fill Color". You'll have to sort it a couple times to get the exact order you want, but it'll group up the colors.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.