How to create a logic statement that changes the formatting of a c

  • Thread starter Thread starter SaraCambridge
  • Start date Start date
S

SaraCambridge

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
 
Back
Top