View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Don't print cell colors, Print font colors.

Before printing, remove the Yellow background from those cells then put it back
after printing.

You could address this by recording a macro whilst doing this.


Gord Dibben MS Excel MVP

On Tue, 12 Feb 2008 10:28:05 -0800, klhetrick
wrote:

I have made cell colors yellow, to denote input data cells. I then want to
print the worksheet in color without printing the yellow background of the
cells. Any suggestions??