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?