Calc Tutorial: Bedingte Formatierung mit Formel – Status offen/erledigt (flexibel & schaltbar)

In this LibreOffice Calc tutorial, I'll show you how to use conditional formatting to highlight tasks so you can instantly see what's open and what's completed. The best part: We'll make it flexible – you can turn the highlighting on and off and even define which status words (or characters) Calc should recognize. ``` ✅ What you'll learn: Automatically mark status in Calc as red/green (open/completed) Conditional formatting with formulas (instead of just "Cell value is...") Use absolute/relative references correctly (e.g., $A2 so the entire row reacts correctly) AND() function for multiple conditions (status + activation switch) Create your own cell/style templates for red and green Optional: Color entire rows instead of just one cell Bonus: Automatically count open/completed tasks at the bottom using COUNTIF 📌 Chapters / Timestamps 00:00 Intro & Goal (flexible, switchable, status freely definable) 00:24 Live Demo: Marking open/completed + toggling on/off 01:33 New Sheet: Structure (status cells + activation switch) 02:56 Select range + conditional formatting → "Formula is" 03:47 $A2 explained: Absolute/relative references for row selection 05:15 AND() logic: Status condition + activation (not empty / toggle) 06:54 Create a red style (e.g., "ToDo open") 08:39 Add a rule for "Done" + green style 12:34 Bonus: Counting open/done with COUNTIF + F4 for $ reference 14:45 Conclusion If this helped you: Leave a like & subscribe for more Calc/Office tutorials. Let me know in the comments whether you prefer using words (open/done) or symbols (e.g., - / ✓) for status. ``` Conditional Formatting: If you're completely new to conditional formatting, you can also watch the tutorial "Conditional Formatting Made Easy (LibreOffice Calc)"    • Bedingte Formatierung ganz einfach (LibreO...   Relative and Absolute References: Relative and absolute references are also a very important topic. If you're not yet familiar with them, you should definitely watch this tutorial, as it will definitely help you: Relative and Absolute References with Examples (LibreOffice Calc)    • RELATIVE und ABSOLUTE BEZÜGE mit Beispiele...   This tutorial is in German. #LibreOffice #Calc #ConditionalFormatting #Tutorial