Hello,
First, thanks for having this forum. It is greatly appreciated. I have a gantt style spreadsheet. I track multiple projects with a start date, due date and a complete date. I currently have the formula =AND(J$5>=$E6,J$5<=$F6) that will highlight a date range, from the start to the due date. It is highlighted in yellow. I would like to keep that same date range and have it change to green when the project is completed. I would also like to have the date range change to red if it goes pass the due date.
I was thinking that I need to have a formula that looks at the date completed verses the date due. If the date completed is equal to or less than the date due, change the date range to green. To change to red, it would be the if =today() is greater than the due date, turn the date range to red. I can't figure out how to combine the different pieces into one formula.
I have attached a test spreadsheet with some dummy data. Any ideas or suggestions would be appreicated.
Thanks Tj
Bookmarks