Conditional Formatting

  • Thread starter Thread starter LinZ
  • Start date Start date
L

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!
 
Conditional formatting formula is:
=LEFT(R2)="*"
Set format, copy cell,
and right-click, paste special formatting to the other cells.
 
Back
Top