Which of the following is not true regarding Conditional Formatting?
2023
Which of the following is not true regarding Conditional Formatting?
- A.
You can add more than one condition to check
- B.
You can set condition to look for Bold and apply Italics on them
- C.
You can apply Font, border and pattern formats that meets the specified conditions
- D.
You can delete any condition from Conditional Formatting dialog box if it is not required
Show answer & explanation
Correct answer: B
Conditional Formatting in a spreadsheet application evaluates each cell's value, formula result, or a built-in rule (duplicate values, top/bottom values, data bars, colour scales, icon sets) against a rule you define, and then applies a chosen format — font style/colour, border, or fill pattern — only to the cells that satisfy the rule. Crucially, the input to a rule is always the cell's content, never the cell's existing formatting attributes such as Bold or Italic — there is no rule type that lets you say "find text that is already Bold" and act on it.
Checking each option against this principle: a rule can certainly test more than one condition at once (stacking multiple rules on the same range), the resulting format you choose can include Font, Border and Pattern changes, and any rule can be removed later from the Conditional Formatting Rules Manager whenever it is no longer needed — all genuine, supported behaviours. What is NOT supported is treating an existing Bold attribute as the search condition and then switching matching cells to Italic — Conditional Formatting has no rule type that reads pre-applied font styling as its trigger.
“Add more than one condition to check” — true; you can layer several Conditional Formatting rules on the same cell range, and they are evaluated in priority order.
“Set a condition to look for Bold and apply Italics on them” — not supported; a rule's condition can only be a cell value, a formula, or a built-in criterion (duplicate/unique, top-bottom, data bar, colour scale), never an existing font attribute like Bold.
“Apply Font, border and pattern formats that meet the specified conditions” — true; the Format Cells dialog inside Conditional Formatting lets you set Font style/colour, Border, and fill Pattern for matching cells.
“Delete any condition from the Conditional Formatting dialog box if it is not required” — true; the Conditional Formatting Rules Manager lets you select and delete any rule you no longer need.
So the statement that does not hold is the one about searching for Bold text and switching it to Italic — that is why it is the option to select for “not true”.