Question

How to format the selected column (column G) to highlight cells with the option 'Light Red Fill with Dark Red Text' if the cell is equal to 'YES'?

Answer 1

To format the selected column (column G) to highlight cells with the option 'Light Red Fill with Dark Red Text' if the cell is equal to 'YES', follow the steps: Select the column range, click on 'Conditional Formatting', choose 'New Rule', select 'Format only cells that contain', choose 'Equal to' and enter 'YES', select the desired format, and apply the formatting.

Step-by-step explanation:

To format the selected column (column G) to highlight cells with the option 'Light Red Fill with Dark Red Text' if the cell is equal to 'YES', you can follow these steps:

1. Select the column range you want to format (in this case, column G).
2. Click on the 'Conditional Formatting' button in the 'Home' tab.
3. Choose 'New Rule' from the drop-down menu.
4. In the 'New Formatting Rule' dialog box, select 'Format only cells that contain'.
5. Choose 'Equal to' from the first drop-down menu and enter 'YES' in the second input box.
6. Select the 'Light Red Fill with Dark Red Text' option from the 'Format' drop-down menu.
7. Click 'OK' to apply the formatting.