Google Sheets Conditional Formatting Rules Flashcards

What does a custom formula rule of =ISODD(ROW()) accomplish when applied to a range?

Answer: Highlights alternating (odd) rows for a banded look

ISODD(ROW()) returns TRUE on odd row numbers, producing zebra-striped alternating rows.

Which custom formula highlights a cell in B2 only when A2 equals 'Yes'?

Answer: =$A2="Yes"

Locking the column with $A2 makes the rule check column A of each row while allowing it to span multiple rows.

In a color scale, what does the 'Midpoint' setting control?

Answer: An optional middle color and its threshold value

The midpoint adds an optional third color at a chosen value type such as percentile, number, or percent.

Which formula flags cells where the text length exceeds 10 characters?

Answer: =LEN(A1)>10

LEN returns the character count of a cell, so LEN(A1)>10 catches long entries.

How can you apply the same conditional formatting rule to multiple non-adjacent ranges at once?

Answer: Enter multiple ranges separated by commas in the 'Apply to range' box

The 'Apply to range' field accepts several ranges separated by commas, applying one rule to all of them.

What happens to a conditional formatting rule when you delete the rows or columns it referenced?

Answer: The rule automatically adjusts or shrinks its range

Google Sheets updates the rule's applied range to reflect deleted rows or columns.

Which condition best highlights cells whose numeric value is between 50 and 100 inclusive?

Answer: Is between 50 and 100

The 'Is between' condition formats values within the specified inclusive range.