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!

Use Conditional Formatting

1. Select the cell say A2. A1 is the cell with YES/NO
2. From menu Format>Conditional Formatting>
3. For Condition1>Select 'Formula Is' and enter the below formula
=A1="NO"
4. Click Format Button>Pattern 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!