AnsweredAssumed Answered

Conditional Formating and/or Parsing

Question asked by mikethecreative on Apr 20, 2015
Latest reply on May 4, 2015 by 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.

Outcomes