randym/axlsx — pull request #183 by straydogstudio (2013-04-04 17:36:33+00:00)
Title: Added support for specifying between/notBetween formula in an array.

Modified conditional_formatting_rule.rb to accept an array or string for formula. This is converted to consecutive val tags if present. Added test. All tests pass.

I thought of minimum/maximum, or formula1 or formula2, but it seemed overbearing.

Tried validation that restricted arrays to :cellIs and :between/:notBetween rules. But, based on my tests with Excel and LibreOffice, second entries are ignored, so the only thing that matters is that the array, if passed, has strings in it.

Added an example also.