View definition

def Axlsx::Worksheet#add_conditional_formatting

Defined in github.com/randym/axlsx/lib/axlsx/workbook/worksheet/worksheet.rb

Description

Add conditional formatting to this worksheet.

Examples:

This would format column A whenever it is FALSE.

# for a longer example, see examples/example_conditional_formatting.rb (link below)
worksheet.add_conditional_formatting( "A1:A1048576", { :type => :cellIs, :operator => :equal, :formula => "FALSE", :dxfId => 1, :priority => 1 }

Parameters:

  • cells (String)

    The range to apply the formatting to

  • rules (Array|Hash)

    An array of hashes (or just one) to create Conditional formatting rules from.

add_conditional_formatting is referenced in 0 repositories