Conditional Formatting with due dates
I'm trying to set up conditional formatting within individual cells. The sheet will have a list of projects and a project completion due date. I'm trying to set up conditional formatting specific to each individual due date. Each project will have it's own row and one of the columns will be the due date column.
Is there a way I can set it up so when a due date gets changed once the date comes and goes. So for example, once two projects have their due dates up, the formatting will change those individual cells with the dates yellow, red, or whatever color.
I've tried doing this but it seems like it wants me to set up the formatting for the entire column. I'm happy to provide more information.
Help Article Resources
Check out the Formula Handbook template!