conditional formatting and printing

S

snazzy

Excel 2007 spreadsheet is using conditional formatting to change the
background of cells dynamically. The print preview nor the printout shows
the cells with the background. Different printers have been tried with the
same results.
 
S

Sheeloo

Are you able to see the colors if you fill the colors in cells without using
Conditional Formatting?

You should be able to see in print preview similar to what you see on
screen...

Make sure that 'Black & White' option in Page Setup->Sheet is not selected.
 
S

snazzy

The background colors di not show up in print preview.
I have checked the Page setup, Sheet and the Black and white box is NOT
checked
If I change the background manually instead of having the conditional
formatting change the background, the colored background appears in both
print preview and printout.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Upgraded from Win 7 to Win 10. Publisher printing black. 1
Descenders clipped 0
Printing Outline view - formatting lost 0
Macro for alternate conditional formatting? 0
print document formatted as booklet without booklet formatting 1
Conditional Format 1
Mail Merge Directory Conditional Page Break 0
Printer not picking up colours from conditional formatting. 0

Top