If the conditions are not mutually exclusive, resulting in more than one specified condition being TRUE, the formatting ____.
A) of the last specified rule overrides those of earlier rules
B) of the first specified rule overrides those of later rules
C) defaults back to match the rest of the spreadsheet
D) is applied by merging the formatting of all of the conditions

Question

Quizplus · Accepted Answer

When there are multiple conditions that are true, Excel applies the formatting of the last specified rule. Therefore, option A is the correct choice.

If the Conditions Are Not Mutually Exclusive, Resulting in More