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