Adjusting Row Borders for Excel Report in nPrinting

[#1]

I'm trying to create an excel report in nPrinting, where there are no cell borders except for above the total row.  I was thinking of either doing this in Qlikview or just adjusting the borders in nPrinting, wasn't sure what was easiest.

I've attached a very quick example as to how I need this to look, was wondering if anyone has an idea as to how to adjust just single rows borders, while having no borders for the rest of the data.

[Daniel_Jenkins]

Hi Gregory,

This is very easy to do in NPrinting using standard Excel formatting.

HTH - Daniel.

[#3]

Hey Daniel,

I appreciate the response, however it isn't that simple, as in nPrinting the format looks more like the attached.

What I need Is for this report to format where it finds the correct row based on the dimension value, and then applies formatting to the other columns.  I've been attempting this using Conditional Formatting and vLookup logic, but so far am not having much luck.

[#4]

Forgot to include my attachment: