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 Sue |
| County | Radford |
| Job # | 48990 |
| | |
| Permit applied | 3/24/2024 |
| Pre-construction meeting scheduled | |
| Pre-construction meeting took place | |
