Help with formula

  • Thread starter Thread starter SS
  • Start date Start date
S

SS

What formula would make this work?

Cell A1 has the word Athens
Cell C2 has the code ATH (using white text to hide it, as this would be the
answer)
In cell D2 type the code (correct answer is ATH)
If wrong answer typed then it types `wrong` if correct then ATH appears

thanks
 
Hi,

=IF(D2=C2,D2,"Wrong Answer")

You would enter this in E2 for example. A few points, hiding answers using
White font is not good, if the cursor is put in the cell the entry still
displays on the Formula bar, and if you highlight more than one cell then the
white fonted text can be seen through the highlight.

If you want the answer Wrong Answer displayed in cell D2, then try this
conditional formatting in 2007 and Data Validation in 2003

In 2003:
1. Select cell D2 and choose Data, Validation, from the Allows drop down
pick List and in the Source box enter =C2.
2. Click the Error Alert tab and enter Wrong Answer in the Error Message box
and the Title box if you wish.
3. Click OK

In 2007:
1. Highlight all the cells on the rows you want formatted
2. Choose Home, Conditional Formatting, New Rule
3. Choose Use a formula to determine which cell to format
4. In the Format values where this formula is true enter the following
formula:
=C2<>D2
5. Click the Format button and choose the Number tab
6. Choose Custom, and enter ;;;"Wrong Answer" on the type line.
7. Click OK twice

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

Select cell D1 and choose
 
Thanks Shane, that has worked for me.
I am not too concerned about the `hidden column` being viewed if
highlighted, as the programme is for my wife who has to learn every airport
code around the world,
so its more of a learning aid and she can `cheat` if she wants :-)....her
choice but she has to sit this as part of an exam.

Thanks again for your help.

regards
 
Hi,

Glad I could help,

Shane Devenshire

SS said:
Thanks Shane, that has worked for me.
I am not too concerned about the `hidden column` being viewed if
highlighted, as the programme is for my wife who has to learn every airport
code around the world,
so its more of a learning aid and she can `cheat` if she wants :-)....her
choice but she has to sit this as part of an exam.

Thanks again for your help.

regards
Click to expand...
 
Back
Top