Erase fill print then bring fill back

G

Guest

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.
 
G

Guest

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?
 
B

Bob I

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

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

Similar Threads

Is there a non-printing shading? 1
Worksheet formatting (fill colors & text colors) disappeared 2
Fill Color Won't Be Edited 2
How to blank the colored cells? 0
if statements 1
Set sheet to "Not Print Fill Color" 1
Cell Fill Color 2
any link or formula to count cells with same color 1

Top