Hi Richard,

'FormatHidden' is one of the pre-defined Styles that you can see from the Format menu and 'Styles'. Essentially, this is pre-defined cell formatting. This hides the row, not just blanking it out. Not only from printing but also viewing.

The 'IF' formulas I used as examples in the prior post typically require some sort of condition in conjuction with 'FormatHidden'. When you hid everything, that could have confused things - if everything is hidden, you won't see anything. You could try a different format such as 'HighlightRed' to get a more visual feel of what is happening.

If you are trying out this 'FormatHidden' formatting, I recommend doing it first without '.RowFormat' in the top-right cell. This allows you to see which rows will be hidden (and which won't be) if .RowFormat was present.

The Help file within the Financial Reporter may give more information that the manual might. In the 'Advanced Report Features' section of the help file (on the home page), there is a link for Row Formatting, which describes this function.