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

Popular posts from this blog

c# - How to get the current UAC mode -

postgresql - Lazarus + Postgres: incomplete startup packet -

javascript - Ajax jqXHR.status==0 fix error -