jSpreadsheet plugin conditional style :
Styles applied :
- Column Mark : Honda is in Orange
- Column Stock : cell checked is in Green
- Column Price : > 3000 is red
- Row alternate : blue and blank
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>