EazyBI - How can I format a cell using two conditions?

[dchisholm]

I have a numeric cell, and I want to format the cell if it's within a range or if it's empty.  I can do one or the other, but not both.

If EazyBI would try empty cells as a numeric "0", then range formatting would solve this.  Or if an empty range matched empty cells, it would be solved.  It doesn't, so I've used a regex of "^$" to match empty cells, but I haven't found a way to use Range and Regex conditions at the same time.

EazyBI version 6.4.2

[dchisholm · Accepted solution]

Found my own answer shortly after posting this question.  I used Range conditional formatting plus a Custom formula.  The formula used "CoalesceEmpty()" to return 0 for empty cells.  That returned value made the Range condition work as expected.