Formatting a cell to print or not to print
 

I want to use the same price list for 2 customers. But, they expect to
receive a price list with only their name on it.
How do I format the cells so that I can "turn" them on or off for printing?

Formatting a cell to print or not to print
 

Suppose you want to turn cells in column D off and cells in column E
on (and vice versa). You can put an X in, say, cell X1 for the first
condition, and a Y in cell X1 for the second condition (or blank for
both D and E to show), then apply conditional formats to the cells
such that one column is turned white when X is entered and the other
column is turned white when Y is entered.

To do this, highlight the cells in column D and click on Format |
Conditional Formatting, and choose Formula Is rather than Cell Value
Is in the first box. Enter this formula:

=$X$1="X"

then click on the Format button, select Color (for foreground) and
choose white. Click OK twice to exit the dialogue box.

Then highlight the cells in column E, click Format | Conditional
Formatting again, and choose Formula Is. Enter this formula:

=$X$1="Y"

then click on the Format button, select Color (for foreground) and
choose white. Click OK twice to exit the dialogue box.

Now if you enter X in X1 then the cells in column D will appear blank,
and if you enter Y into X1 then the cells in column E will appear
blank.

Hope this helps.

Pete

On Feb 19, 8:47*pm, lob wrote:
I want to use the same price list for 2 customers. But, they expect to
receive a price list with only their name on it.
How do I format the cells so that I can "turn" them on or off for printing?