Specific conditional formatting of cells

I went through this a bit with Simon and he was very helpful, but it turns out that the set of criteria is very complicated. I wonder if I would be able to pose this question in the delegate forum once I'm back at work with my material in front of me?