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.

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.

Thank you - I checked and checked for a black and white checkbox to be
checked yesterdy - this morning - you were so sure that one was checked I
went back in and sure enough one was.

"Sheeloo" wrote:

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.