Conditional Formatting Quiz

What you'll be asked

1. What is the primary purpose of using conditional formatting in a report?
2. If you want to highlight all cells in a 'Sales' column that are greater than $5,000 in red, which feature should you use?
3. When applying a '3-Color Scale' to a range of numbers, how does the formatting determine the colors?
4. Which of the following scenarios is best suited for using 'Icon Sets'?
5. You have two overlapping conditional formatting rules applied to the same cell range. Rule A sets the background to blue if the value is > 100. Rule B sets the background to yellow if the value is > 50. If the cell value is 120, how does the system resolve this?

Answers and explanations come after you submit.