If you have your current salary in column A, new salary in column B, $
variance in column C, % variance in column D, input $ variance in cell F2 and
input % variance in cell G2;

in cell A2 enter in conditional formating condition 1 =$C2$F$2, then press
the add button to show condition 2, in condition 2 enter =$D3$G$2

Set the formats to whatever you want, i.e. yellow background?
Then select cell A1, press the match properties icon and select the entire
list.

this will then make any row where the $ variance is greater than the input $
variance or the % variance is greater than the input % variance, or both,
yellow.

"Fletch" wrote:

The variance limit input area is for changes greater than amount input In
this case anything greater than $10,000 and 10%. We are trying to simplify
the review of our salary changes to highlight any changes that fall outside a
normal expected range (both increases and decreases)

If someone were to input variance amounts of $10,000 and 10% in my input
area, I want the cells in my example to turn yellow. I would also want the
cells highlighted if the salary amounts in my example were $50,000 and
$25,000 with variances of -$25,000 and -50%