AnsweredAssumed Answered

Conditional formatting if the word "fee" is present

Question asked by JackiefromPortland on Dec 7, 2013
Latest reply on Dec 7, 2013 by 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

Outcomes