content_image/684790.jpg content_image/684791.jpg content_image/684792.jpg content_image/684793.jpg
<img src='content_image/684790.jpg'>

3. Hover over Highlight Cells Rules . 

4. Select Equal To  to open the Equal To dialogue box. 

<img src='content_image/684791.jpg'>

5. Enter the value that you’re looking for. 

6. Select the type of cell formatting you wish to use. 

7. Select Ok . 

The cells which contain the specified value will now appear with the cell formatting which you selected. 

## Text That Contains 

To highlight cells that contain a certain character(s): 

1. Highlight the data range. 

2. Select Conditional Formatting . 

<img src='content_image/684792.jpg'>

3. Hover over the Highlight Cells Rules . 

4. Select Text That Contains  to open the Text That Contains dialogue box. 

<img src='content_image/684793.jpg'>

5. Enter the character(s) you’re looking for. 

6. Select the type of cell formatting you wish to use. 

7. Select Ok . 

