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
|