In the app I'm working on, if a student's projected completion date has passed and if the student hasn't completed, I want to flag the date by making it red and bold. So I have the following as a formatting condition, because I couldn't figure out how to exclude the DNF status:
And([projected_date]<TODAY(),
([status]<>"Completed"))
It works--except if a student's status is "DNF", and the projected date has passed, that data also turns red and bold. I want neither for the [status]="DNF" students.
I created another rule to remove the red formatting, but I cannot un-do the bold text.
How do I add an "exclusion condition" to the expression? If that's not possible, how do I make some text NOT bold?
LinkedIn
Twitter
