View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo Sheeloo is offline
external usenet poster
 
Posts: 793
Default conditional formatting and printing

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.

"snazzy" wrote:

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.