IconSet

[Łukasz Włodarczyk]

Hi,

I would like to know if it is possible to trigger formula like 'lessThan' or other ones for the IconSet

For example following one display result based on percentage:

icon_set = Axlsx::IconSet.new
    ws.add_conditional_formatting 'B3:B7', { :type => :iconSet,
                                             :dxfId => profitable,
                                             :priority => 1,
                                             :icon_set => icon_set }

How I can adjust add_conditional_formatting in order to trigger it based on the number and specific formula like:

sheet.add_conditional_formatting "D3:D#{i}", { :type => :iconSet,
                                                     :operator => :between,
                                                     :formula => ["0","4"],
                                                     :priority => 1,
                                                     :icon_set => icon_set }
Is it possible? If not how can I at least trigger it based on number not percentage and how can I adjust the ranges?