Color text to indicate Correct or Wrong.

[joaquinwalking]

Is there an excel function to color text to indicate a correct and wrong answer? I'm thinking of using an IF THEN statement to compare two cells. If the numbers are equal then color them green, if wrong color them red automatically.

[FDibbins]

You would use Conditional Formatting for this.

1. highlight the range you want to apply the conditional formatting to
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =A1=B1 format Green

Create a New Rule, repeat 3 and 4 with =A1<>B1

If you dont want to use a 2ned rule, you could simply format all cells green with regular formatting, then use 1 rule for teh color change (=A1<>B1)

[joaquinwalking]

Thank-you for the information.

I'm going to give it a try.

Best regards,


JoaquinWalking