Adding a IF formula to an AND formula

Good morning.    I am trying to set up a project calendar for my marketing department and found that using conditional formatting was the best way to do it for what we need instead of using a Gantt...