Forum Discussion

MarkD72's avatar
MarkD72
Copper Contributor
Dec 15, 2022
Solved

Conditional Formatting based on a % of a min / max value

Hello I've created a table where I would like to track a monthly actual value against a set min and max tolerance threshold - example below.        Key Risk Indicator (over 12 month per...
excel
Formulas and Functions
  • mtarler's avatar
    mtarler
    Dec 15, 2022

    MarkD72 I created 1 Lambda function and 6 conditional formatting rules

    the lambda was:

    LcolVal = LAMBDA(in, INDEX(in, XMATCH(TRUE, ISNUMBER(in), 0, -1)))

    the rules are:

     

HansVogelaar's avatar
HansVogelaar
MVP
Dec 15, 2022

MarkD72 

On which column(s) should the color of Appetite Status be based?

Resources