Question: here are multiple conditional formatting rules applied to cells in the Financial Data worksheet. Make changes to the conditional formatting rules on this worksheet only.
here are multiple conditional formatting rules applied to cells in the Financial Data worksheet. Make changes to the conditional formatting rules on this worksheet only.
There should be three conditional formatting rules: a Top rule, a Bottom rule, and an Icon Set rule. Delete all the extra rules.
Correct the cell range for the remaining rules. All the rules should be applied to cells D:G
Fix the remaining conditional formatting rules so if the value of the cell is in the top values or the bottom values, the icon rule is not applied.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
