2 Replies Latest reply on Dec 7, 2013 12:36 PM by JackiefromPortland

    Conditional formatting if the word "fee" is present

    JackiefromPortland

      Title

      Conditional formatting if the word "fee" is present

      Post

           Need a calculation, please! 

           I want one field to turn yellow if an adjacent field contains the word "fee." 

           The field that will/will not contain "fee" is populated from this value list: 

           Hourly Payroll
           W2 Flat Fee
           Placement Fee
           Conversion Fee
           NIKE HOURLY
           Referral Fee
           Find/Fetch Fee
           1099 Flat Fee
           1099 Hourly
            
           (We are a staffing agency. Recruiters are the users of this database.)
            
           If the selected value is fee related, the recruiter needs to type in what that fee is. 

           Is that enough information to help me write this script? Thank you! 

            

            

      fee.JPG