Conditional Formatting
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!
|