jSpreadsheet plugin conditional style :




Styles applied :


plugins: [
        { name:'conditionalstyle', plugin:jexcel_conditionalstyle, options:{rules:[
               {range:"B1:B10;1:1", criteria: "Honda", class:"cellAlert"},
               {range:"G:G", criteria: ">3000", style:{"color": "red", "font-weight":"bold", "background-color": "LightPink"}, stopIfTrue:true},
               {range:"F:F", criteria: true, style:"background-color:green", stopIfTrue:true},
               {criteria: "=IF(MOD(ROW(),2)==1, true, false)", style:{"background-color": "lightblue"}, stopIfTrue:true},                        
           ]}},
],

This plugin is a premium plugin available on Repo of JSpreadsheet plugins

Download full version Documentation

you can try this plugin in limited version in your jspreadsheet in localhost :


<script src="https://demo.gbonnaire.fr/dist/jexcel.conditionalstyle.js"></script>