Cell bordered without printing

[Bob Vance]

Is there some way you can have a cell bordered but it will not print?
Thanks in advance for your help....Bob Vance
..
..
..
..

 

[Debra Dalgleish]

You can set a print area that doesn't include the cell. Or, you can use
conditional formatting to add the cell border, and hide it when
printing. There's an example here:

http://www.contextures.com/xlCondFormat03.html#Print

 

[Bob Vance]

what condition do I put in for any text within the cell?

--
Thanks in advance for your help....Bob Vance
..
..
..
..

 

[Debra Dalgleish]

Using cell D4 as the example:

Select cell D4
Choose Format, Conditional Formatting
From the first dropdown, choose Formula Is
In the formula box, type: =D4<>""
Click the Format button, and select the borders you want
Click OK, click OK