c# - how to add conditional formatting on cells with values greater than a specific constant value using epplus -
i have made excel sheet programmatically. , want add conditional formatting on specific cell range.
the formatting type cells values greater 0 (>0)
how go doing it? in excel can using inbuilt formula of cell values greater than
. how embed in excel using c# , epplus?
i coudnt find exact solution problem. adding own solution works
var celladdress = new exceladdress( <startingrow>, <startingcolumn>, <endingrow>, <endingcolumn>); var cf = ws.conditionalformatting.addgreaterthan(celladdress); cf.formula = "0"; cf.style.fill.backgroundcolor.color = color.lightgreen;
Comments
Post a Comment