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
....her