This question already has an answer here:
I have a Google spreadsheet. There is a colour column. Every row has a colour, Red, Yellow, Green etc. I want to be able to filter out say all rows that are Red, all rows that are yellow, all rows that any colour except Green, Green rows only etc.
Any tips on how to do this? I want to do this so the user viewing the spreadsheet can do it dynamically.