| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create a logic statement that changes the formatting of a c
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to create a logic statement that changes the formatting of a c
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| logic statement | Excel Discussion (Misc queries) | |||
| Logic Statement | Excel Discussion (Misc queries) | |||
| Need help w/ logic statement in excel | Excel Worksheet Functions | |||
| rather complex logic statement | Excel Worksheet Functions | |||
| Logic Statement | Excel Worksheet Functions | |||
Linear Mode
