How to Highlight Cells That Contain a Question Mark in Microsoft Excel and Google Sheets

Microsoft Excel

1. Open your Excel workbook and select the range of cells where you want to highlight cells containing a question mark.
2. Go to the Home tab in the Ribbon, and in the Styles group, click on Conditional Formatting.
3. Select New Rule.
4. In the New Formatting Rule dialog box, select Format only cells that contain.
5. In the rule description, select Specific Text from the first dropdown, containing from the second dropdown, and then type ? in the third field.
6. Click on the Format button to choose your desired format (like a specific fill color).
7. Click OK to close the Format Cells dialog box, then OK again to close the New Formatting Rule dialog box.

More about conditional formatting in Excel.

Google Sheets

1. Open your Google Sheets document and select the range of cells where you want to highlight cells containing a question mark.
2. Click on Format in the menu, then select Conditional formatting.
3. In the Conditional format rules pane, under Format cells if..., select Text contains.
4. Enter ? in the field that appears.
5. Under Formatting style, choose your desired format (like a specific fill color).
6. Click Done.

More about conditional formatting in Google Sheets.

Summary This tutorial guides you on how to highlight cells containing a question mark in Microsoft Excel and Google Sheets. By using conditional formatting, you can automatically apply a specific format to cells that meet certain conditions.