Thursday, February 11, 2010

How do I do a true/false and color function together in excel?

I already have the true/ false part correct so that False or True will show up with the correct terms, but I would like the formula to also do like a background color of red if the answer is FALSE %26amp; yellow if it's TRUE. How do I do that?How do I do a true/false and color function together in excel?
You can do it with Conditional formatting. Select the cell with True or False in it, then conditional formatting and set what you want.How do I do a true/false and color function together in excel?
Webdesign Tips And Tricks


http://freshbloger.com/

No comments:

Post a Comment