Thread: If statement
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default 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