In conditional formatting what happens if the cell value does not pass the logical test?
A)The cell is formatted however you have determined for the FALSE result.
B)The cell is formatted with Excel's default FALSE format.
C)The cell is not formatted.
D)A small green triangle displays in the top-left corner of the cell.

Question

Quizplus · Accepted Answer

If the cell value does not pass the logical test in conditional formatting, the cell is not formatted. Conditional formatting only applies the specified formatting if the condition is met; otherwise, the cell remains in its default or previously set format.

In Conditional Formatting What Happens If the Cell Value Does