Question

In the Mileage Log worksheet, apply conditional formating to the Descriptioncolumn that highlights cells that contain the text Deliver with a Light Red Fill with Dark Red Text.

Answer 1

To apply conditional formatting to the Description column in the Mileage Log worksheet, select the cells and use the 'Conditional Formatting' feature. Set the formula to search for the text 'Deliver' and choose the desired fill and text colors.

Step-by-step explanation:

To apply conditional formatting to the Description column in the Mileage Log worksheet, follow these steps:

1. Select the cells in the Description column.
2. Click on the 'Conditional Formatting' button in the toolbar.
3. Choose 'New Rule' from the dropdown menu.
4. In the dialog box, select 'Use a formula to determine which cells to format'.
5. Enter the formula =SEARCH("Deliver",A1)>0, where A1 is the first cell in the selected range.
6. Click on the 'Format' button and go to the 'Fill' tab.
7. Choose the desired light red fill color and dark red text color.
8. Click 'OK' to apply the formatting.