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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!