Change cell color based on date from another sheet
I'm working on a project overview sheet for many overlapping timelines. I'd like to make it so that if any of the projects have the date that the column is named that cell highlights or changes color.
So, for example, if project 1 timeline had a date associated with 9/12/21 then the cell joining those two would change color.
Would it also be possible to change color based on what is listed in the primary column of the Project 1 timeline. For example, if the timeline has 9/12 within the timeline and the primary column says "submit to legal" the cell on the overview sheet turns blue. but if it says "hand off to contractor" the cell on the overview sheet turns green.
Thanks in advance!
Help Article Resources
Check out the Formula Handbook template!