Question

4. Naomi wants to highlight the brass instruments she and Kaito bought on the same date. Apply a conditional formatting rule to the range E3:E10 that uses Green Fill with Dark Green Text for duplicate values.

Answer 1

To highlight duplicate values in the range E3:E10 using conditional formatting, select the range and apply a rule to format duplicate values with green fill and dark green text.

Step-by-step explanation:

To apply a conditional formatting rule to highlight duplicate values in the range E3:E10:

1. Select the range E3:E10.
2. Go to the 'Home' tab.
3. Click on the 'Conditional Formatting' button in the 'Styles' group.
4. Select 'Highlight Cells Rules' and then click on 'Duplicate Values'.
5. In the 'Duplicate Values' dialog box, choose 'Format only unique or duplicate values'.
6. Select 'Duplicate' in the 'Format all' drop-down menu.
7. Choose the desired formatting, like 'Green Fill with Dark Green Text'.
8. Click 'OK' to apply the conditional formatting rule.