Using Conditional Formating To Change The Backgound Color Of The Cells

I have been using Conditional Formating to change the backgound color of the cells, this works fine. However it cannot be used with a userform text box. There I believe that the use of If Then Else statements will sort out the problem.

I have developed three conditions:

1) D10 less than E5 result True
2) D10 less than F5 result True
3) D10>E5 result False

using that result background color to turn green

Next condition
1) D10 less than E5 result False
2) D10 less than F5 result True
3) D10>E5 result True
using that result background color to turn yellow

Next condition
1) D10 less than E5 result False
2) D10 less than F5 result False
3) D10>E5 result False
using that result background color to turn red

What I cant seem to do is combine the three instances above so that the cell back color changes.

This is so easily done using the built in conditional format function but I'm have a difficulty understanding how to make this work.