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! |
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! |
All times are GMT +1. The time now is 12:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com