Dropdown List with Data Validation
To create a dropdown list:

  • Choose a cell
  • Click Data in the top menu
  • Choose Data validation in dropdown menu
  • Next to Criteria choose list of items
  • Enter your items, separated by comma
  • Click save
data vallidation

Conditional Formatting
To apply conditional formatting to your dropdown list:

  • Choose a cell
  • Choose Format in the top menu
  • Create Format rules
  • Choose color of your choice to your rule
  • Add so many rules as your like
  • Click save
Match Function

Filter View
To create a filter view:

  • Choose a row or a cell
  • Click Data in the top menu
  • Choose Filter Views in dropdown menu
  • Choose Create new filter view
  • Name your filter
Index Match