Need help with series Color Expression to include more than two conditions
Hello Demantra Experts,
I am trying to create a color expression for a series to include multiple conditions but have not been successful.
Here are the conditions I would like to include for this series:
Series name: 4 Week Lag Absolute Pct Err
Conditions:
1 - If 4 Week Lag Absolute Pct Err is more than 10% and less 100% make these cells red.
2 - If 4 Week Lag Absolute Pct Err is less than 10% (& more than 0%) make these cells green.
3 - Anything Else make them black.
I have got to this so far If(4 Week Lag Absolute Pct Err>0.1 AND 4 Week Lag Absolute Pct Err<1,255)