Need to change color on spreadsheet for due date and passed due date

That was not meant as an answer. I told you to attach a workbook and I gave you instructions on how to do that. No one wants to create their own "version" of an unseen workbook guessing as to unknown layout and data formats just to try to help you.

Rule #12:
Don't quote whole posts -- it's just clutter. If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding.