I have a master list of trading cards. I'd love to be able to use a color coding system. For example, if Green is cards I've already collected, when I highlight the background of the cell green, I want it to create a list on a separate page using the contents of those highlighted cells. Is there a way to do this?

  • Welcome. On this site tags question title should not include tags (we have a tag system for tagging question, by the way tags have tag excerpts and wikis with use guidelines). Regarding the content of your question please add a brief description of your search/research efforts as is suggested on How to Ask. – Rubén Jun 26 '19 at 21:34
  • perhaps try like this using conditional formatting and data validation:

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.