Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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.

share|improve this question

migrated from superuser.com Feb 13 '12 at 21:18

This question came from our site for computer enthusiasts and power users.

1 Answer 1

Literally, you can't (see this topic on Google Group).

You'd better use the Google Conditional Formating system:

  • Highlight a new column
  • Click the tool to select a color
  • Choose to "change with rules"
  • Create a match, e.g. cell contains "x" equals red
  • Then when you sort that column you'll get sorting by color.
share|improve this answer
2  
Better yet, instead of "x" use values of "red", "yellow", and "green" (etc.). Use conditional formatting to colorize the cells properly, plus your filter options will be easy to understand! –  Benj Feb 13 '12 at 22:43

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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