Home » Posts

Highlight cells that end with

Note: Excel contains many built-in rules for highlighting values with conditional formatting, including a rule to highlight cells that end with specific text. However, if you want more flexibility, you can use your own formula, as explained in this article. If you want to highlight cells that end with certain text, you can use a simple formula based on the COUNTIF function. For example, if you want to highlight states in the range B4:G12 that end with "ota", you can use: =COUNTIF(B4,"*ota") Note: with conditional formatting, it's important that the formula be entered relative to the "active cell" in the selection, which is assumed to be B4 in this case.

April 14, 2025 · 1 min · 59 words · Anthony Richardson

As a result, the conditional formatting rule will respond instantly whenever that value is changed.

Finally EXACT compares the extracted text to the text you are looking for (the substring).

EXACTiscase-sensitive, so only will return TRUE when all characters match exactly.

Excel formula: Highlight cells that contain

For example, =RIGHT(“apple”,3) returns “ple”.

LEN will also count characters in numbers, but number formatting is not included.

Excel formula: Highlight cells that begin with

Excel COUNTIF function

Excel RIGHT function

Excel LEN function

Excel EXACT function