Changing Colour of Cells (Influenced by Drop Down List)

[Karelia Suite]

Hello!

Please take a look at the simple spreadsheet I have attached to this post. If we take row 2 as an example, you can see there is a drop down option on cells D2 and E2. The only value that can be displayed in these cells is either Yes or No.

I would like the following rules to apply to Row 2, Cells A to E:-

If Cell D2 is "Yes" and Cell E2 is "Yes" - Cells A2 to E2 are shaded green.
If Cell D2 is "Yes" and Cell E2 is "No" - Cells A2 to E2 are shaded orange.
If Cell D2 is "No" and Cell E2 is "Yes" - Cells A2 to E2 are shaded orange.
If Cell D2 is "No" and Cell E2 is "No" - Cells A2 to E2 are shaded red.

I believe conditional formatting only allows you to change the cell colour determined by the value in that cell, so I am not sure how to make other cells change as determined by the value in an adjoining cell.

Hope someone can help me, many thanks in advance.