In Google Sheets, cells, rows, or columns can be formatted to change text or background color if they meet certain conditions. Teachers can use this feature to highlight standout or failing grades, specific form entries that were completed on a certain date or mention you by name, and so much more. Select all the rules available for conditional formatting.
Choose an answer
Tap an option to check your answer.
Correct answer: A. Is not empty, B. text contains, C. date is, D. is empty, E. custom formula is.
Why this is the answer
All listed options (Is not empty, text contains, date is, is empty, custom formula is) are valid conditional formatting rules in Google Sheets. These rules allow users to apply specific formatting (like changing text color or background color) to cells, rows, or columns when the data within them meets the defined criteria. For example, "Is not empty" highlights cells with any content, while "text contains" highlights cells where the text includes a specific phrase. "Date is" applies formatting based on date conditions, and "is empty" highlights blank cells. "Custom formula is" provides the most flexibility, allowing users to define complex conditions using Google Sheets formulas.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed