--Select the range of cells. Assume this range is A1:A7
--Goto Home tabStylesConditional FormattingManage rulesNew ruleFormat
only cells that contain
--Cell valueequal to
--Click the Format button
--Select the desired style(s)
OK

Likewise add all 3 conditions.

If this post helps click Yes
---------------
Jacob Skaria


"Lynne" wrote:

I am working with a value matrix in Excel 2007. Each category's response
field is set up as a data validation drop down menu. The person responding
clicks on the drop down and chooses good, fair, or bad to a particular
question
Can I use conditional formatting to change the color of the response
depending on whether the person chooses good, fair, or bad from the drop down
menu?

Thanks,