| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Grey out Cell content
I am make a worksheet with yes and no option boxes. I want to have certain
text in the worksheet greyed out if a question is answered no. Is there a way to do this? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Grey out Cell content
hi
yes. sounds like a job for conditional fomating. read up on conditional formating in help also see..... http://www.contextures.com/xlCondFormat01.html regards FSt1 "MWysack" wrote: I am make a worksheet with yes and no option boxes. I want to have certain text in the worksheet greyed out if a question is answered no. Is there a way to do this? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Grey out Cell content
Link the No checkbox to a cell on the worksheet. The cell will show
"TRUE" when the checkbox is checked, and "FALSE" when it's unchecked. Then, for the cells you want to grey out, use conditional formatting to check the value of the linked cell and format accordingly. --JP On Jan 22, 3:35*pm, MWysack wrote: I am make a worksheet with yes and no option boxes. I want to have certain text in the worksheet greyed out if a question is answered no. Is there a way to do this? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Grey out Cell content
hi
afterthought. in case you aren't sure, use the linked cell property of the option button to trigger the conditional formating. the cell(s) you want grayed out, the CF in those cells should be something like formula is....=B2=Fasle (or True) regards FSt1 "FSt1" wrote: hi yes. sounds like a job for conditional fomating. read up on conditional formating in help also see..... http://www.contextures.com/xlCondFormat01.html regards FSt1 "MWysack" wrote: I am make a worksheet with yes and no option boxes. I want to have certain text in the worksheet greyed out if a question is answered no. Is there a way to do this? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Grey out Cell content
Thank You!
"FSt1" wrote: hi afterthought. in case you aren't sure, use the linked cell property of the option button to trigger the conditional formating. the cell(s) you want grayed out, the CF in those cells should be something like formula is....=B2=Fasle (or True) regards FSt1 "FSt1" wrote: hi yes. sounds like a job for conditional fomating. read up on conditional formating in help also see..... http://www.contextures.com/xlCondFormat01.html regards FSt1 "MWysack" wrote: I am make a worksheet with yes and no option boxes. I want to have certain text in the worksheet greyed out if a question is answered no. Is there a way to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum if cell = grey | Excel Worksheet Functions | |||
| The clear filter from a a heading cell is grey out | Excel Worksheet Functions | |||
| Grey out cell | Excel Worksheet Functions | |||
| grey dot in left upper corner of cell | Excel Discussion (Misc queries) | |||
| Cell borders printing black instead of grey | Excel Discussion (Misc queries) | |||
Linear Mode
