making a cell go red when answer in questionnaire is wrong
 

i am making a questionnaire and i am trying to do it so when the question is
answered then if it is wrong it goes red or if it is right then it goes blue
or green. i cannot find the formula for this can someone please let me know
what it is.

thanks

making a cell go red when answer in questionnaire is wrong
 

Hi,

Use Format Conditional Formating
Be more specific if you need a precise answer ...


HTH
Cheers
Carim

making a cell go red when answer in questionnaire is wrong
 

I believe Conditional Formatting is what you need.
See Debra Dalgleish's website for instructions:
http://www.contextures.com/xlCondFormat01.html

Does that help?
***********
Regards,
Ron

XL2002, WinXP


":D" wrote:

i am making a questionnaire and i am trying to do it so when the question is
answered then if it is wrong it goes red or if it is right then it goes blue
or green. i cannot find the formula for this can someone please let me know
what it is.

thanks