I can try to describe.
IF(H6>G6,[Blue]"Yes",[Red]"No") is one part and then IF(H6>G6 and E6>D6,[Green],"Yes",[Orange],"No")
In reality, I would chnage the result cell to Windings2 font so that an Up or own arrow will appear. Based on my results, the Up arrow may need to be Blue or Green and the Down Arrow may need to be Red or Orange. Thank you for assisting.

PS: I have updated my profile to show I have 2010 at home, but I am restricted to 2003 Excel at my place of employment.