4 Replies Latest reply on May 4, 2015 10:25 PM by mikethecreative

    Conditional Formating and/or Parsing

    mikethecreative

      Title

      Conditional Formating and/or Parsing

      Post

      Field examples:

             
      1. "1357 - Female Blouse"
      2.      
      3. "1837, 9362, 2946 - Male Short Sleeve Shirt"

       

      I want to use Conditional Formatting to change the color of all text before the dash ( "-" ).

             
      • Example 1 - change the color of "1357"
      •      
      • Example 2 - change the color of "1837, 9362, 2946"

       

      How can I do this? I have tried a lot of different combinations of Left, LeftWords, Postion, etc and cannot figure it out. Any help would be appreciated.