Liang also wants to identify the work for which Forward Construction has billed more
than the full estimate amount. In the range 15:114, use conditional formatting Highlight Cells rules to format values less than 1% (0.01) in Light Red Fill with Dark Red Text
To highlight values less than 1% (0.01) in Light Red Fill with Dark Red Text using conditional formatting in the range 15:114, follow these steps:
1. Select the range 15:114 where you want to apply the conditional formatting.
2. Go to the "Home" tab in the Excel ribbon.
3. Click on the "Conditional Formatting" button in the "Styles" group.
4. From the dropdown menu, select "New Rule".
5. In the "New Formatting Rule" dialog box, select "Format only cells that contain".
6. In the first dropdown menu, select "Cell Value" and choose "less than" as the second dropdown option.
7. Enter the value "0.01" in the third textbox.
8. Click on the "Format" button.
9. In the "Format Cells" dialog box, go to the "Fill" tab.
10. Choose a light red color (or any desired color) for the fill and click "OK".
11. Go to the "Font" tab in the "Format Cells" dialog box.
12. Choose a dark red color (or any desired color) for the text and click "OK".
13. Click "OK" again in the "New Formatting Rule" dialog box.
14. The values less than 1% (0.01) in the range 15:114 will now be highlighted with light red fill and dark red text.
This conditional formatting will help Liang easily identify the work for which Forward Construction has billed more than the full estimate amount.