Conditional Formatting

[LinZ]

I am trying to format rows R2:R187 to change the font red and bold if it
starts with *.

For example: *Have Amanda review payment of $25.00*.

I need to leave the dollar amount open ended because it changes everytime.
Also, occasionally comments will be added into the same cell underneath the
above note, and I do not want that formatted.

Thanks!

 

[Luke M]

Conditional formatting formula is:
=LEFT(R2)="*"
Set format, copy cell,
and right-click, paste special formatting to the other cells.

 

[stew]

Try This
in conditional formatting
=LEFT(R2:R187,1)="*"

Stew