I have been messing with conditional formatting all day and have no idea how to figure this out.

Please help us as this is will greatly help our unit save so much time, thank you so much!!

PS: I manually colored these boxes to show how I wish the formatting would look like after inserting formular/rules.

​I have been messing with conditional formatting all day and have no idea how to figure this out.Please help us as this is will greatly help our unit save so much time, thank you so much!!PS: I manually colored these boxes to show how I wish the formatting would look like after inserting formular/rules.  Read More

​