Highlight cells that end with

Generic formula 

=COUNTIF(A1,"*text")

Summary 

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")

A simpler, more flexible rule using named ranges

By naming an input cell as a named range and referring to that name in the formula, you can make the formula more powerful and flexible. For example, if you name G2 "input", you can rewrite the formula like so:

=COUNTIF(B4,"*"&input)