Conditional formatting

render_settings 

Let's say the values in C2:D100.

Select this range. The active cell in the selection should be in the top row, i.e. C2 or D2.

On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula

=AND($C2=TRUE, $D2=TRUE)

Click Format...
Activate the Fill tab.
Select green as highlight color.
Click OK, then click OK again.

Repeat these steps, but with the formula

=AND($C2=FALSE, $D2=FALSE)

and red.

Finally, repeat them again with the formula

=OR(AND($C2=TRUE, $D2=FALSE), AND($C2=FALSE, $D2=TRUE))

and yellow.