Google Tabellen: Aufgaben automatisch rot/grün markieren (offen/erledigt + Schalter + ZÄHLENWENN)

In this Google Sheets tutorial, I'll show you how to tag tasks so you can instantly see what's open and what's completed. The best part: You can flexibly control the tagging – freely define status words and even show/hide the colors (using checkboxes). ``` ✅ In this video, you'll learn: Automatically color rows red/green based on status (e.g., "open / completed" or symbols like "-" / "x") Conditional formatting with a custom formula Freeze a column (e.g., $A2) so entire rows react correctly Use the AND() function: Status matches and checkbox is active Toggle the marker on/off with a checkbox (separately for open and completed) Bonus: Count open/completed tasks using COUNTIF and an absolute reference 📌 Chapters / Timestamps 00:00 Intro & Goal 00:20 Demo: Status symbols (- / x) + Red/Green 00:40 Toggle marker on/off (Checkbox) 01:01 Change status text (open/completed instead of symbols) 01:21 Bonus: Automatically count open/completed tasks 02:03 Setup: New table + status/toggle columns Creating 02:44 Insert checkboxes (Insert → Checkbox) 03:17 Select range + Open Conditional Formatting 04:02 Rule 1 (OPEN): Formula with $A2 + status cell + AND() + RED 08:40 Rule 2 (COMPLETED): Second formula + AND() + GREEN 11:41 COUNTIF: Dynamically count open/completed cells 13:27 Conclusion & Outro If this helps you: Thumbs up & subscribe for more spreadsheet tutorials. Feel free to write in the comments which status words you use (e.g., "in progress," "waiting," "done"...). Conditional formatting made easy: If you're completely new to conditional formatting, feel free to check out the following tutorial. Here I show you a bit more about conditional formatting in Google Sheets:    • Bedingte Formatierung ganz einfach (Google...   Relative and absolute references: If you're not yet familiar with relative and absolute references, you should definitely watch this tutorial. It will definitely help you a lot, especially when it comes to copying formulas.    • Relative und absolute Bezüge ganz einfach ...   #GoogleSheets #ConditionalFormatting #Tutorial