View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
SteW SteW is offline
external usenet poster
 
Posts: 293
Default 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!