View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default 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.