Recall & Review
beginner
What is conditional formatting in Excel?
Conditional formatting is a feature that changes the look of cells automatically based on rules you set, like coloring cells if they contain certain values.
Click to reveal answer
beginner
How do you apply conditional formatting to highlight cells greater than 100?
Select the cells, go to Home > Conditional Formatting > Highlight Cells Rules > Greater Than, then enter 100 and choose a format.
Click to reveal answer
beginner
What types of formats can conditional formatting change?
It can change cell fill color, font color, font style (bold, italic), and add icons or data bars.
Click to reveal answer
intermediate
Can conditional formatting use formulas? If yes, why?
Yes, formulas let you create custom rules based on any condition you want, like comparing values in different cells.Click to reveal answer
intermediate
What happens if multiple conditional formatting rules apply to the same cell?
Excel applies the rules in order. The first rule that matches can override others, but you can change rule order and stop if true.
Click to reveal answer
Which menu do you use to start conditional formatting in Excel?
✗ Incorrect
Conditional formatting is found under the Home tab in Excel.
What does conditional formatting do?
✗ Incorrect
Conditional formatting changes how cells look based on conditions you set.
Which of these can you NOT change with conditional formatting?
✗ Incorrect
Conditional formatting changes appearance, not the actual formulas in cells.
To highlight cells less than 50, which rule type do you choose?
✗ Incorrect
Use the 'Less Than' rule to highlight cells with values below a number.
What is the benefit of using a formula in conditional formatting?
✗ Incorrect
Formulas let you create flexible, custom rules for formatting.
Explain how to apply conditional formatting to highlight cells with values above a certain number.
Think about the steps from selecting cells to setting the rule.
You got /8 concepts.
Describe how conditional formatting rules are applied when multiple rules affect the same cell.
Consider how Excel decides which format to show.
You got /5 concepts.