Hightlight a record in a table using status and due date

if ([Status] = "In Progress" and [Due Date] < Today(), "red", "")

The way it works is like this
IF("CONDITION" , "Result if True", "Result if False")

can also use  hex colors, black is #00000 for example.

Chuck, thanks what if its if status does not equal and due date

I ask because I have five statuses and we don't want to highlight the completed records 

you would use != for NOT EQUAL TO

Not equal is <> in Quick Base.

News to me if != also works.

You're right, javascript is !=, quickbase uses <>

Now, I am receiving this message, "The expression [Process Due Date] on the left hand side of the operator "<>" is of type date while the expression "Green" on the right hand side is of type text. The operator "<>" cannot be used with these types of expressions."_

Could you paste your formula? Sounds like a syntax issue, Green should be after the condition, separated by a comma. Like [Process Due Date] < Today(), "Green

I fixed it; but this is the formula: If ([REC Status] <> "Green" and [Process Due Date] < Today(), "orange", "")

Thanks for all your help

Awesome! Glad you got it working!