Conditional formatting from multiple cells

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 i...