Need help with a formatting expression

[yumei]

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?

[Suvrutt_Gurjar]

Maybe this

AND([projected_date]<TODAY(),
OR([status]<>"Completed",[status]<>"DNF")
)

[yumei]

It doesn't quite work. The result I want, in plain language is this:

When [projected_date]<TODAY() and [status]<>"Completed", make the letters red--EXCEPT when [status]="DNF" (even if  [projected_date]<TODAY())

How do you express the "EXCEPT" idea in AppSheet?

[Suvrutt_Gurjar · Accepted solution]

This?

AND([projected_date]<TODAY(),
[status]<>"Completed", [status]<>"DNF")

[yumei]

Ah YES! That works. Thank you!

Side note: So you can put more than one condition in an expression!

[Suvrutt_Gurjar]

Yes, an expression in general can have many conditions. Exceptions are there depending on how you build expression.