Google Sheets: Conditional Formatting & Dropdowns

Wishlist Share

About Course

Make Google Sheets highlight what matters and keep data entry consistent. Learn how to set up conditional formatting rules, colour scales and custom formulas, and how to use dropdowns and data validation so that people can only enter sensible values.

Tutwoo is an independent learning provider and is not affiliated with or endorsed by Google. Menu names and features can vary and change with updates. This course is general skills training and is not an accredited qualification.

What Will You Learn?

  • Highlight overdue items, duplicates and key values automatically Use custom formulas to format whole rows Create dropdown lists from typed values or a range Reject or warn about invalid entries

Course Content

Course Lessons

  • Conditional formatting basics
  • Custom formula rules
  • Dropdowns
  • Data validation for numbers, dates and text

Sources & Further Reading
The official guidance this course is based on.

Final Assessment

Student Ratings & Reviews

No Review Yet
No Review Yet

Want to receive push notifications for all major on-site activities?

✕