Hide Cell content from Printing

I

igbert

Is there a way to hide a cell content from printing based on the value of
another cells?

i.e. If Cell A1 is blank, hide the cell content of B1 from printing, and
if Cell A2 is blank, hide the cell content of B2 from printing, and
so on.

Igbert
 
D

Dave O

One idea: use conditional formatting. If A1 is blank, use white
colored font in cell B1. It will print white on a white background:
unreadable.

Maybe?

Dave O
Eschew obfuscation
 
I

igbert

Hi Dave O,

Correct me if I am wrong. This method also hides the content in B1. The
content only shows in the formula bar. But I want to show the content in the
grid as well. I wonder if know any VBA could do the job.

Thanks.

Igbert
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top