|
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?
|