If statement

[Guest]

I have set up a simple spreadsheet for my son to use to study his vocabulary
words. He enters the letters A-L in a column and if he enters them correctly
I have it setup to read super or awesome in another column. I would also
like to incorporate into my if statement something that would fill in the
cell that matches in yellow color. I currently have the formula IF(B1=C1,
"Super", "Try Again") he enters the answer in B and I have entered the
correct answer in C but hide column C. Is it possible to use the IF
statement to color fill a-l yellow if correct

 

[Niek Otten]

Look in HELP for Conditional Formatting

 

[PCLIVE]

Use Conditional Formatting. Format-Conditional Formatting.
For cell B1.
Cell Value is equal to =C1

Change the Format-Patterns.
Select desired color.

HTH,
Paul