View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
homer homer is offline
external usenet poster
 
Posts: 47
Default Erase fill print then bring fill back

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

"Bob I" wrote:

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

Homer wrote:

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?

"Gord Dibben" wrote:


FilePage SetupSheet.

Checkmark in "Black and White"


Gord Dibben MS Excel MVP

On Tue, 25 Sep 2007 11:14:04 -0700, Homer
wrote:


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.