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!

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

Luke M
*Remember to click "yes" if this post helped you!*


"LinZ" wrote:

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!

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

Stew

"LinZ" wrote:

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!