17  5. Enter the character(s) you’re looking for. 6. Select the type of cell formatting you wish to use. 7. Select  Ok . 4. Select  Text That Contains  to open the Text That Contains dialogue box.  3. Hover over the  Highlight Cells Rules . 2. Select  Conditional Formatting . 1. Highlight the data range. 5. Enter the value that you’re looking for. 6. Select the type of cell formatting you wish to use. 7. Select  Ok . 3. Hover over  Highlight Cells Rules . 4. Select  Equal To  to open the Equal To dialogue box.  The cells which contain the specified value will now appear with the cell formatting which you selected.  To highlight cells that contain a certain character(s):  Text That Contains 