Excel 2007 : print conditional formating

**cassiopea** · 07-03-2012, 03:37 AM

Hi!

In Excel 2007 spreadsheet I have a simple table with data and I used conditional formating to draw border lines arond the data in a form "if there is data put border line, else no border". And it works fine, but this line is not shown on print preview, nor on the real printout. Why is that and how can I fix it.
Thanks

**Richard Buttrey** · 07-03-2012, 04:28 AM

Hi,

You'll need to upload the workbook so that we can see the problem in context.
One thought, are you sure you are including the cells which contain the border in the range being printed?

**cassiopea** · 07-03-2012, 05:15 AM

I made a simple example file with the problem. So, the line made by conditional formating is there on the screen, but when I print the sheet out, there is no line.

**Richard Buttrey** · 07-03-2012, 08:59 AM

Then Upload the workbook as suggested

**cassiopea** · 07-03-2012, 09:36 AM

I did - in first post.

**Richard Buttrey** · 07-03-2012, 09:49 AM

You have applied your formatting to the cells in column D and since they are blank column D won't be included in the Print range.

You can demonstrate this easily by putting a space character in D1 and then printing the sheet.