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