The Percent Difference Test makes it possible to highlight values that are `x% higher` or `x% lower` than the reference value.
Returns "high" if target value is greater than or equal to the upper bound. Returns "low" if target value is less than or equal to the lower bound. x = input_value / 100 upper_bound is ref_cell * (1.0 + x) lower_bound is ref_cell * (1.0 - x) (The "target value" is the value of the cell being tested. "ref_cell" is the value tested against).
Enter the input value as a percentage without the % sign. So, a value of "10" would represent 10 percent.
Click on a cell and enlarge the Cell Info Window to view the calculated lower and upper bounds:
In this screenshot, the cursor is hovering over the target cell (3%). The reference cell is the cell to the left in grey (2%).
The above example shows the benchmark test, but you may use the other tests too, such as the 'standard test':