View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
LinZ LinZ is offline
external usenet poster
 
Posts: 4
Default Conditional Formatting

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!