How to Highlight Cells that End a Text String

- How to Highlight Cells that Contain a Text String
- How to Highlight Cells that not Contain a Text String
- How to Highlight Cells that Start a Text String

Using conditional formatting, you can quickly highlight all the cells that end with a text string. Please follow the steps below:

Step 1: Select the data range;

Step 2: Click the "Home" tab from the Ribbon;

Step 3: Click the "Conditional Formatting" command in the "Styles" section;

Step 4: Click the "Highlight Cells Rules" command from the drop-down list, then select "More rules" from the extended list;

Step 5: Set up the rules in the "New Formatting Rule" window;

- In the first box, select "Specific Text";

- In the second box, select "ending with";

- In the third box, enter the text string, e.g., "S";

Step 6: Click the "Format" button and select the formatting style in the "Format Cells" window, e.g., fill the cells with blue;

Step 7: Click "OK" at the bottom and you will see the cells ending with "S" are now in blue.

Leave a Reply