Grey out Cell content

  • Thread starter Thread starter MWysack
  • Start date Start date
M

MWysack

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?
 
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
 
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
 
Thank You!

FSt1 said:
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
Click to expand...
 
Back
Top