Complicated Conditional Formatting

Hi.  I am trying to create an excel "Live" document where there are 4 date columns that I would want to draw conditional formatting from.  there is a picture attached but ill explain it here as well....