Conditional Formatting if Cell Contains Text in Excel

Conditional formatting in Excel allows you to automatically apply formatting to cells based on certain conditions. You can use conditional formatting to highlight cells that contain specific text.

Here's an example of how to apply conditional formatting if a cell contains text in Excel:

Example

1. Open your Excel workbook and select the range of cells where you want to apply the conditional formatting. For example, A1:A10.
2. Go to the "Home" tab on the Excel ribbon, and click on "Conditional Formatting" in the "Styles" group.
3. In the drop-down menu, choose "Highlight Cells Rules" and then select "Text that Contains..."
4. In the "Text that Contains" dialog box, enter the specific text you want to find in the "Format cells that contain the text" field. For example, "apple".
5. Choose the format you want to apply when the cell contains the specified text. You can choose from the default options (Light Red Fill with Dark Red Text, Yellow Fill with Dark Yellow Text, or Green Fill with Dark Green Text) or click on "Custom Format" to create your own format.
6. If you choose "Custom Format", the "Format Cells" dialog box will open. Here, you can customize the font, border, and fill settings for your conditional formatting rule. Once you have set your desired format, click on "OK".
7. Click on "OK" in the "Text that Contains" dialog box to apply the conditional formatting rule to the selected cell range.

Now, any cell in the selected range that contains the specified text will be formatted according to the rule you have created.

Remember, you can always edit, delete, or modify your conditional formatting rules by going to "Conditional Formatting" > "Manage Rules" in the "Home" tab on the Excel ribbon.