how to display different row colour in Excel Nprinting report

[#1]

how to display custom row color in Excel Nprinting report,

Example: Based on one field value I have to change the color for entire row.

If Comment field is not null then I have to display the row in green else rest rows to display in regular color.

[Daniel_Jenkins · Accepted solution]

Hi Mahesh,

You can use Excel's Conditional Formatting feature.

I have attached a project that demonstrates your requirement (display row in green if Comment field is not NULL).

Extract to folder C:\Temp\Community\029 to preserve the paths used or change them in the NSQ.

HTH - Daniel.

[#3]

Hi,

We can achieve by using excel feature functionality called conditional formatting, below url provides the details with an example,

It works!..

Excel: Change the row color based on cell value

Thanks,

Mahesh