We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

How to set a rule for Cell to render in different color?

im using smart marker approach to generate excel report. I have a "Amount" column in the report. If the amount in the column is negative then i want that cell to appear in red color.

Instead using programatic approach is there any way to set a rule in the template itselft for that column, so that the cell will render in red when the value is negative.

if this is not possible then what is the easiest approach to do this?


Set the style of the entire amount column. You can either set it with Ms-Excel in your template file or you can set it programmatically using Aspose.Cells for .NET.

Please see the following article to see how to set the style of entire column
Formatting Rows & Columns