Conditional Formatting Question

I am working on a Job List for employees at my company. The list is simple and contains information like Date, Customer, Job #, and so on. Most importantly one column is STATUS.

My question is:
Is there a formula that will change a rows font color and shading if the "Status" cell contains a specific word or if the due date is today?

Yes.. you can set a conditional format based on a formula and that is what you would need.

In the conditional format FORMULA enter =OR($D2="myStatus",$A2=Today())

where column A is the DATE column and column D is the STATUS column.
Also, the number 2 should represent the first row that the conditional formatting is applied to (which should also be the first row where the data starts)

You can then apply this formula to the entire range/row that you want formatted and set that formatting.

Will this work for a list of statuses? Example: If the Status is Hold, Credit Hold, Hold - Scott, or Hold Tim I want the row to turn red with white font. If the Status is Proofing or Quoting, I want the row to turn Yellow with Black font. If the Status is Pre-press, Production, or Ready for Install I want the row to be green with black font. Also if the Due Date is today I want the row to turn Red with white font.

Thank you very much. I will try this out and see If I can make it work.

This did not work. :-(
When I put the code in as described I et this error message:
"You may not use unions, intersection, or array constants for Conditional Formatting criteria."