When using multiple conditional formatting rules,which of the following statements is true?
A) The order of the rules is unimportant.
B) The order of the rules is important.
C) Access continues to evaluate rules after a match is found.
D) all of the above

Question

Quizplus · Accepted Answer

The order of the conditional formatting rules is important because Access evaluates them in order from top to bottom. If a cell meets the criteria of multiple rules, only the first rule will be applied unless the "Stop if True" option is selected. Thus, the order in which the rules are listed affects the resulting formatting. The other statements are incorrect as Access stops evaluation after the first matching rule is found.

When Using Multiple Conditional Formatting Rules,which of the Following Statements