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