Google Sheets Conditional Formatting Rules Flashcards

Which custom formula highlights a row where the value in column D matches a target listed in cell $G$1?

Answer: =$D1=$G$1

Locking the column ($D1) applies across the row while an absolute $G$1 keeps the comparison target fixed.

What is the effect of using =AND(A1>0, B1<100) as a custom conditional formatting formula?

Answer: Formats only when both conditions are true

AND requires every argument to be TRUE, so both conditions must be satisfied for the format to apply.

Which approach highlights cells that contain a specific word regardless of surrounding text?

Answer: Text contains

'Text contains' matches whenever the substring appears anywhere in the cell.

To make conditional formatting reference another sheet's value, what must you use inside the custom formula?

Answer: An INDIRECT or a range imported to the same sheet

Conditional formatting formulas can't directly reference other sheets, so you use INDIRECT or bring the value onto the current sheet.

Which custom formula highlights blank cells in a range?

Answer: =ISBLANK(A1)

ISBLANK returns TRUE for empty cells, flagging them for formatting.

How do you remove a single conditional formatting rule without affecting others?

Answer: Hover the rule in the panel and click the trash/remove icon

Each rule has its own remove (trash) icon in the conditional format rules panel.

Which condition would highlight the top 10% of values in a range using a gradient?

Answer: Color scale with maxpoint set to percentile

A color scale using a percentile maxpoint emphasizes the highest-ranked values with the strongest color.