Scope Yes / No is one column.
If scope yes then, Variance % is >= 0.02 % or Variance % is <= -0.02 is then Amount to be conditional formatting with red colour and any symbol to be displayed in the next column.
Thanks in advance for helping the critical condition.
Something like this. Hard to do without the actual data/names.
IF [Scope] = "Yes"
THEN IF [Variance %] >= .02 OR [Variance %] <= .02
THEN "Red" ELSE "Other Color"
ELSE "Out of Scope"
Retrieving data ...