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.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
