If statement
 

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
--
Anita

If statement
 

Look in HELP for Conditional Formatting

--
Kind regards,

Niek Otten

"Anita Howard" wrote in message
...
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
--
Anita

If statement
 

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

Change the Format-Patterns.
Select desired color.

HTH,
Paul

"Anita Howard" wrote in message
...
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
--
Anita