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
Answer :