| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Erase fill print then bring fill back
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Erase fill print then bring fill back
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Erase fill print then bring fill back
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Erase fill print then bring fill back
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Erase fill print then bring fill back
File, Page Setup, Sheet, Print, Tick "Black and white" checkbox.
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum contents of comments based on back fill colour | Excel Discussion (Misc queries) | |||
| Some formulas don't track copies, pastes, fill right, fill down | Excel Discussion (Misc queries) | |||
| Fill in form to type Item descrictions and costs and fill in funct | Excel Worksheet Functions | |||
| I have a list of data, fill in the gaps. FILL function won't work | Excel Discussion (Misc queries) | |||
| The fill feature in Excel that gives option to fill or copy | New Users to Excel | |||
Hybrid Mode
