Question: statement about the conditional formatting rules is true? A . Using a rule, you can compare any cell to a number or any other cell;
statement about the conditional formatting rules is true?
A Using a rule, you can compare any cell to a number or any other cell; if the formula is true, the formatting is applied.
B Take care to avoid absolute cell references in conditional formatting rules, as they cannot be edited later.
C To use a formula as the basis of a conditional formatting rule, you create the formula in the worksheet and then choose that cell in the Rules Manager.
D You can't rearrange the order of rules after they're set because it will skew the results.
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
