Use Conditional Formatting

1. Select the cell say A2. A1 is the cell with YES/NO
2. From menu FormatConditional Formatting
3. For Condition1Select 'Formula Is' and enter the below formula
=A1="NO"
4. Click Format ButtonPattern and select your color (say Grey)
5. Hit OK

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


"SaraCambridge" wrote:

I would like to program an Excel workbook to change the color of a cell or
the color of the font in a cell when the contents of another cell changes.
For example, if I answer NO to a question, then the next question is grayed
out.

Thank you for your help!