Easy excel question..

[Fiveohhh]

I have an if statement and if its true I got the word pass to come up, and if its false it says fail. is there a way to make the fail appear red and the false appear blue?
Thanks

 

[Mitzi]

Originally posted by: Fiveohhh
I have an if statement and if its true I got the word pass to come up, and if its false it says fail. is there a way to make the fail appear red and the false appear blue?
Thanks

Sure is.... use conditional formatting (Format->Conditional Formatting). Simply set up two rules, one if the cell contents equals 'True' and one if equals 'False'.

 

[Fiveohhh]

I have my statement setup, just wondering if its possible to change the colors for each answer

 

[kranky]

Mitzi answered your question correctly. Use conditional formatting and the color will change depending on the cell contents.

 

[Mitzi]

Originally posted by: Fiveohhh
I have my statement setup, just wondering if its possible to change the colors for each answer

As kranky said, you can apply conditional formatting after the formulas have been setup and are working. You can then use the 'Format Painter' tool to copy the conditional cell formatting setup to any other required cells.

 

[Fiveohhh]

Cool, I got it figured out thanks for the help I misread your answer the first time mitzi

 

[Mitzi]

Glad I could help...I've been writing some pretty nasty workbooks myself lately too...