Forum Discussion

tfarinholt's avatar
tfarinholt
Copper Contributor
Oct 21, 2024

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 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
CountyRadford
Job #48990
  
Permit applied3/24/2024
Pre-construction meeting scheduled 
Pre-construction meeting took place