Erase fill print then bring fill back

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Homer - 25 Sep 2007 19:14 GMT

I have a workbook with multiple sheets. In the sheets I have cells filled
with various colors indicating where information is input by me or where it
is automaticaly input. This is done with varying types of conditional
formatting. When I print I would like to print with no cells colored but then
return to the colored cells.

Reply to this Message

Gord Dibben - 25 Sep 2007 19:26 GMT

File>Page Setup>Sheet.

Checkmark in "Black and White"

Gord Dibben MS Excel MVP

>I have a workbook with multiple sheets. In the sheets I have cells filled
>with various colors indicating where information is input by me or where it
>is automaticaly input. This is done with varying types of conditional
>formatting. When I print I would like to print with no cells colored but then
>return to the colored cells.

Reply to this Message

Homer - 25 Sep 2007 21:18 GMT

This works with one exception. This also makes the company logo print b&w.
Is there any way to have the cells no fill and the logo still print with
color?

> File>Page Setup>Sheet.
>
[quoted text clipped - 7 lines]
> >formatting. When I print I would like to print with no cells colored but then
> >return to the colored cells.

Reply to this Message

Bob I - 25 Sep 2007 22:29 GMT

A workaround in this case could be to take a copy of the file and delete
all the conditional formatting.

> This works with one exception. This also makes the company logo print b&w.
> Is there any way to have the cells no fill and the logo still print with
[quoted text clipped - 11 lines]
>>>formatting. When I print I would like to print with no cells colored but then
>>>return to the colored cells.

Reply to this Message

Homer - 26 Sep 2007 13:50 GMT

Not quite what I want, but thank you for trying to help. I'll keep working
on it.

> A workaround in this case could be to take a copy of the file and delete
> all the conditional formatting.
[quoted text clipped - 14 lines]
> >>>formatting. When I print I would like to print with no cells colored but then
> >>>return to the colored cells.

Reply to this Message

Bob I - 25 Sep 2007 19:37 GMT

File, Page Setup, Sheet, Print, Tick "Black and white" checkbox.

> I have a workbook with multiple sheets. In the sheets I have cells filled
> with various colors indicating where information is input by me or where it
> is automaticaly input. This is done with varying types of conditional
> formatting. When I print I would like to print with no cells colored but then
> return to the colored cells.

Reply to this Message