addConditionalFormatting - cfsimplicity/spreadsheet-cfml GitHub Wiki

Adds a conditionalFormatting rule object to a workbook.

addConditionalFormatting( workbook, conditionalFormatting )

Required arguments

• workbook spreadsheet object
• conditionalFormatting ConditionalFormatting object: built with newConditionalFormatting()

Chainable? Yes.

Related

newConditionalFormatting()

Examples

formatting = spreadsheet.newConditionalFormatting()
  .onCells( "A1:B1" )
  .whenCellValueIs( "GT", 100 )
  .setFormat( { fontColor: "GREEN" } )
workbook = spreadsheet.newXlsx()
spreadsheet.addConditionalFormatting( workbook, formatting )

formatting = spreadsheet.newConditionalFormatting()
  .onCells( "A1:B1" )
  .when( "$A1<0" )
  .setFormat( { fontColor: "RED" } )
spreadsheet.newChainable( "xlsx" )
  .addConditionalFormatting( formatting )
  //more chained calls...