You can use conditional formatting. Select the cell you want to change
colors and then navigate to FORMAT...CONDITIONAL FORMATTING. Where it
says "Cell Value Is",Change it to "Formula Is" then enter "True" in the
text box to the right. Now select the Format button and select the
color you want displayed. Select the "Add" button and repeat the
process for false.
