KB11 - Why does my Row formatting for a particular row disappear?

Description

Formatting (such as background color) for the entire row disappears in the generated workbook.

Solution

This happens when there is no cell on the sheet. To prevent this just put a blank string in any cell of the row (ie. just type ' and press enter). Your formatting for the row should now be preserved.