5 Points: XL Activity 210: Applying Conditional Formatting by Using Highlight Cells Rules and Data Bars Apply conditional formatting to the selected range F15:F44 a cell within the range contains Standard Colors. Change the Fill color to No Color. formatted with a Dark Red font color-in the first column, the first color under

To apply conditional formatting to the selected range $F15:F44$ in Excel, follow these steps:<br /><br />1. Select the range $F15:F44$.<br />2. Go to the "Home" tab on the Ribbon.<br />3. In the "Styles" group, click on "Conditional Formatting."<br />4. Choose "Highlight Cells Rules" from the dropdown menu.<br />5. Select "Text that contains" from the submenu.<br />6. In the "Text that contains" dialog box, enter "Dark Red" in the "Format" field.<br />7. Click "OK" to close the dialog box.<br />8. The selected range $F15:F44$ will now be formatted with a Dark Red font color.<br /><br />To change the Fill color to No Color, follow these steps:<br /><br />1. Select the range $F15:F44$.<br />2. Go to the "Home" tab on the Ribbon.<br />3. In the "Font" group, click on the arrow next to the "Fill Color" button.<br />4. Choose "No Color" from the dropdown menu.<br /><br />By following these steps, you can apply conditional formatting to the selected range $F15:F44$ with a Dark Red font color and change the Fill color to No Color.