Question: QUESTION 5 You have created two conditional formatting rules for a cell that both evaluate as TRUE (i.e., the conditional formatting rules conflict) How does

QUESTION 5 You have created two conditional formatting rules for a cell that both evaluate as TRUE (i.e., the conditional formatting rules conflict) How does Excel determine which rule takes precedence within the Conditional Formatting Rules Manager? a) The one that is positioned higher in b) The one that was created first the list of rules c) The one that is positioned lower in d) Excel makes a guess based on the the list of rules context of the cell e) It is randomly determined f) The one that was modified most recently g) Based on selection in the Edit Rule:s h) None of the above menu
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
