Google Sheets Conditional Formatting Rules Flashcards
7 cards from real Google Sheets Test practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Google Sheets Conditional Formatting Rules flashcards as text
Which custom formula highlights weekends (Saturday or Sunday) based on a date in column A?
Answer: =WEEKDAY($A1,2)>5
WEEKDAY with type 2 returns 6 for Saturday and 7 for Sunday, so >5 flags weekends.
What does the 'Text does not contain' condition do?
Answer: Formats cells missing a given substring
It applies formatting to cells that do not include the specified substring.
Which custom formula highlights cells where the value differs from the cell directly to its left?
Answer: =B1<>A1
Comparing B1<>A1 flags cells whose value is not equal to the neighbor on the left.
When you copy a cell with conditional formatting and paste it elsewhere, what is pasted by default with a normal paste?
Answer: Value plus the conditional formatting rule
A standard paste carries both the content and the conditional formatting rule, extending the rule's range.
Which formula highlights cells containing an error value?
Answer: =ISERROR(A1)
ISERROR returns TRUE when a cell holds an error like #DIV/0!, allowing it to be flagged.
What is a key advantage of using a custom formula rule over a built-in single-color condition?
Answer: It can reference multiple cells and combine complex logic
Custom formulas allow multi-cell references and logical functions, enabling conditions the preset options can't express.
Which custom formula highlights every cell in a row when that row's checkbox in column E is TRUE?
Answer: =$E1=TRUE
Locking the column with $E1 checks each row's checkbox while spanning all columns of the row.
How this page was made: written with AI tools. We have not yet matched this exam's facts to an official source, so confirm fees, dates and rules with the exam body. Not reviewed by a subject-matter expert. Editorial policy