I have a pre-construction schedule and I want the job info section to change color based on where it is in the pre-construction schedule. So in my document I have a lot more info but it is arranged into columns. When the building permit is applied for, a date will be entered. Same for the pre-construction meeting cells. Ideally, once the BP is applied for and a value is entered, I want cells B1:B3 to turn blue. Once a pre-con meeting date is scheduled, I want those same 3 cells to turn yellow. And once the meeting has occurred, the last date would trigger green. Please let me know if this is do-able or if I’m wasting time. Thank you!

Name

Sally SueCountyRadfordJob #48990  Permit applied3/24/2024Pre-construction meeting scheduled Pre-construction meeting took place 

​I have a pre-construction schedule and I want the job info section to change color based on where it is in the pre-construction schedule. So in my document I have a lot more info but it is arranged into columns. When the building permit is applied for, a date will be entered. Same for the pre-construction meeting cells. Ideally, once the BP is applied for and a value is entered, I want cells B1:B3 to turn blue. Once a pre-con meeting date is scheduled, I want those same 3 cells to turn yellow. And once the meeting has occurred, the last date would trigger green. Please let me know if this is do-able or if I’m wasting time. Thank you!NameSally SueCountyRadfordJob #48990  Permit applied3/24/2024Pre-construction meeting scheduled Pre-construction meeting took place   Read More

​