Stopping colours from printing in Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lalaggia - 10 Dec 2007 00:07 GMT

I have some conditional formatting to change cell colours to green if they
are =0. When I print the spreadsheet, I would like the coloured cells to
print white.

I did change the spreadsheet to print black and white, which stops the
colour from printing except that in the cells where the Totals of a column
are, the zero's show up even though the font in the cell is set to white if
it's = 0.

I would also like to know how to stop the pop up to enable/disable macros
that displays every time you open the workbook. This spreadsheet is going to
muliple users.

Reply to this Message

Gord Dibben - 10 Dec 2007 00:18 GMT

You could also Custom Format those cells to ::: (3 semi-colons) and they won't
print in B&W or Color.

The only way to stop the pop-up for macros is to ensure all users have their
security set to "Low".......not a good idea and hard to enforce.....or sign your
project with a digital signature which you can purchase.

Gord Dibben MS Excel MVP

>I have some conditional formatting to change cell colours to green if they
>are =0. When I print the spreadsheet, I would like the coloured cells to
[quoted text clipped - 8 lines]
>that displays every time you open the workbook. This spreadsheet is going to
>muliple users.

Reply to this Message

lalaggia - 10 Dec 2007 01:39 GMT

Thanks for your input Gord.

The conditional formatting colours those cells if they are empty. If they
are not empty, I need the value of those cells printed, so I'm not sure if
that would work.

Linda

> You could also Custom Format those cells to ::: (3 semi-colons) and they won't
> print in B&W or Color.
[quoted text clipped - 17 lines]
> >that displays every time you open the workbook. This spreadsheet is going to
> >muliple users.

Reply to this Message

Gord Dibben - 10 Dec 2007 17:35 GMT

Your original post stated

>> >I have some conditional formatting to change cell colours to green if they
>> >are =0.

Now you state the CF changes the cell to green if empty.

What's prints if the cell is empty?

If first statement is true then you would remove the custom format of ;;; before
printing.

Gord

>Thanks for your input Gord.
>
[quoted text clipped - 25 lines]
>> >that displays every time you open the workbook. This spreadsheet is going to
>> >muliple users.

Reply to this Message

Rate this thread: