Use conditional formatting and add the conditions in sequence (thanks, Phil).
You can apparently ignore the FM help:"When you set multiple formatting conditions on an object, all conditions are evaluated starting from the top of the list. Each condition that evaluates “true” is appended to the objects previous format settings.", as I've just tried it with yellow > 5 and red >10 and it works. Maybe it adds formatting like bold, italic on top of existing conditional formatting.
Thanks Phil. I got the colors to work on the dates in the Final Due field. Now my dilemma is the final step.
If the Project Status field contains "done", the date in the Final Due field should be black.
Since this involves data from one field to change the text color in a different field, is that a formula that I need to add to the conditional formatting? What might that look like?
Thanks again for you help.