I am using conditional formatting to generate different colors in cells based on project status.
Green is project is complete
Blank is project is in progress
Yellow is project is in progress, but it is overdue by 1 week or less
Red is not complete and overdue by 1 week
I have different steps and each step has an expected date column and an actual date column. Currently, I only have dates for the expected date column, not the actual date (bc the actual dates have not taken place yet). The expected dates are currently in the future. For example, here are my dates in the estimated column.
Does anyone know how to complete conditional formatting in the actual date column with the criteria stated above?