Conditional formatting based on dynamic values

avelio

Currently it's not supported to dynamically configure condition formatting on the OCR column since we can't add field value in conditional formatting. And it's not supported to set conditional formatting based on another column.

So you may add another column to assign static value and configure conditional formatting on that column.

Tag =
IF (
    Table1[OCR] < Table1[LowBound],
    1,
    IF (
        Table1[OCR] >= Table1[LowBound]
            && Table1[OCR] <= Table1[HighBound],
        0,
        -1
    )
)

Regards,