Color coding cells that contain some substring

[srkj]

Hello:

I have some data shown below in a spreadsheet.

[TABLE="width: 94"]
<colgroup><col span="2"><col><col></colgroup><tbody>[TR]
[TD] g[/TD]
[TD] z[/TD]
[TD] g[/TD]
[TD] s[/TD]
[/TR]
[TR]
[TD] r[/TD]
[TD] b*[/TD]
[TD] h[/TD]
[TD] c[/TD]
[/TR]
[TR]
[TD] n[/TD]
[TD] u*[/TD]
[TD] e[/TD]
[TD] r
[/TD]
[/TR]
</tbody>[/TABLE]

Each string (g, z, u*, b*...) is in its own cell.

I am trying to highlight the cells that has *.

I tried Conditional Formatting --> Highlight Cells Rules..-->Text That Contains --> *

But it appears that this rule reads the whole string and doesn't recognize the substring.

I am wondering whether there is anyway to achieve the highlighting based on the substrings in a value

thank you

 

[srkj]

OK. It appears that I need to use "Conditional Formatting Based on the Formula"

Conditional Formatting --> New Rule--> New Formatting Rule --> Use a formula to determine which cells to format.

The formula is -- highlight all the cells which contain * at the end of the string.

=RIGHT(CELL_REFERENCE,1)="*"

Any tips on how to reference all the cells in the active sheet generically?

 

[srkj]

OK Folks. This issue is resolved. I need to use the following in the formula to highlight those cells that contain *

=RIGHT(A1:T20,1)="*"

 

[srkj]

OK Folks. This issue is resolved. I need to use the following in the formula to highlight those cells that contain *

=RIGHT(A1:T20,1)="*"