View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_5_] Sheeloo[_5_] is offline
external usenet poster
 
Posts: 248
Default conditional format printing problem

Are you sure that 'Black and White' checkbox is clear in Page Setup | Sheet
options?

Also verify that the current printer is not set to pring in black and white...

Since you see it in print preview at least one of the above is setto 'black
and white'
-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"mesc" wrote:

I have set a conditional format to be white font. When the condition is met
it changes the font to white. This hides the cell information from the
spreadsheet. However, when I print the spreadsheet the same cell information
prints out black. When I look in print preview I see the information also.
This is a shared worksheet on a network with a couple different printers. The
spreadsheet is set to color both in Excel and on the printer properties.