Question

In the range H5:H13, use conditional formatting highlight cells rules to format values less than 1% (0.01) in light red fill with dark red text.

a) Apply conditional formatting as described
b) Format cells greater than 1%
c) Format cells less than 5%
d) No conditional formatting needed

Answer 1

To highlight cells less than 1% in the range H5:H13 using conditional formatting, follow these steps.

Step-by-step explanation:

To use conditional formatting to highlight cells in the range H5:H13 that are less than 1% (0.01), follow these steps:

1. Select the range H5:H13.
2. Go to the 'Home' tab and click on 'Conditional Formatting' in the 'Styles' group.
3. Choose 'New Rule' from the drop-down menu.
4. Select 'Format only cells that contain'.
5. In the 'Format only cells with' drop-down menu, choose 'Less than'.
6. Enter '0.01' in the text box.
7. Click on the 'Format' button and go to the 'Fill' tab.
8. Select a light red fill color.
9. Go to the 'Font' tab and select a dark red text color.
10. Click 'OK' to apply the conditional formatting.