AnsweredAssumed Answered

Conditonal formatting calc

Question asked by heatherwilliams on Oct 9, 2017
Latest reply on Jan 30, 2018 by heatherwilliams

I'm trying to add conditional formatting when the data in the advisor_appointment field is not "Tenured or tenure-track faculty" or "Research faculty" AND when the advisor_non_regular field is empty. It was working until I added the second set of conditions.

 

In the Conditional Formatting dialogue box I added a condition where "Formula is" (Self≠ "Tenured or tenure-track faculty" and IsEmpty ( Research Grants::advisor_non_regular )) or  (Self  ≠  "Research faculty" and IsEmpty ( Research Grants::advisor_non_regular )). What did I do wrong?

Outcomes