Hi, Im trying to do some conditional formatting based on certain cells. I'm limited to what I can show so hopefully this is enough to go on.

The logic I need is:

Show green if(and...N2=yes, o2=0,p2=0,q2=0, r2/s2/t2 all equal g2....Show yellow if not all the previous are true but x2=yes....otherwise show red?

Is this possible? Any help would be appreciated. thanks!