Question

Apply conditional formatting to the selected range F15:F44, so that if a cell within the range contains the word Discontinue, the cell text will be formatted with a dark red font color---in the first column, the first color under Standard Colors, Change the Fill color to No Color.

Answer 1

To apply conditional formatting to a range in Excel, follow these steps: select the range, go to the 'Conditional Formatting' menu, choose 'New Rule', enter the formula, and format the cells with the desired color.

Step-by-step explanation:

To apply conditional formatting to the selected range F15:F44, follow these steps:

1. Select the range F15:F44.
2. Go to the 'Home' tab in the Excel ribbon.
3. Click on the 'Conditional Formatting' button and choose 'New Rule'.
4. In the 'New Formatting Rule' dialog box, select 'Use a formula to determine which cells to format'.
5. In the 'Format values where this formula is true' field, enter the formula '=SEARCH("Discontinue", F15)>0'.
6. Click on the 'Format' button.
7. In the 'Format Cells' dialog box, go to the 'Font' tab.
8. Select the 'Color' dropdown and choose the 'Dark Red' color under 'Standard Colors'.
9. Click on the 'Fill' tab.
10. Select the 'No Color' option.
11. Click 'OK' to apply the conditional formatting.