Question: How would you prevent Excel from applying more than one conditional format to a PivotTable cell? a. In the conditional formatting rules manager, right-click the
How would you prevent Excel from applying more than one conditional format to a PivotTable cell?
a. In the conditional formatting rules manager, right-click the rule and then click apply this rule only
b. Go to the excel options dialog box, display the formatting page, and check the apply single conditional format only box
c. No action is needed-- this is a default behavior
d. Check the Stop If True box next to the rule in the conditional formatting rules manager
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
