Match the following Conditional Formatting Options in the Quick Analysis Gallery with their description:
i. Text Contains
II. Duplicate Values
III. Unique Values
IV. Equal To
v. Clear Format
A) Formats cells that have exactly the same value
B) Formats any cell that has content that matches the first content in the first selected cell
C) Removes any conditional formatting
D) Formats cells that have no matching values
E) Formats cells that have the value

Question

Quizplus · Accepted Answer

The Answer of Match the following Conditional Formatting Options in the Quick Analysis Gallery with their description:
i. Text Contains
II. Duplicate Values
III. Unique Values
IV. Equal To
v. Clear Format
A) Formats cells that have exactly the same value
B) Formats any cell that has content that matches the first content in the first selected cell
C) Removes any conditional formatting
D) Formats cells that have no matching values
E) Formats cells that have the value

Match the Following Conditional Formatting Options in the Quick Analysis