View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
klhetrick klhetrick is offline
external usenet poster
 
Posts: 4
Default Don't print cell colors, Print font colors.

I didn't really want to remove and put back the cell colors. I have multiple
sheets and areas to do this in. Thank you for your input.


"Gord Dibben" wrote:

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