Spreadsheet with 4 columns and many rows. Two columns of data, third column
is a variance (A-B), fourth column is % variance (Column 3 divided by column
1). I have an input area where a user can input a dollar and % variance. I
want to highlight the rows where both the dollar and % variance limits have
been met. The calculated variance can be both positive or negative.

For example, column 1 = salary $50,000, Column 2 = salary $75,000, column
3 = $25,000 variance, column 4 = 50% variance.

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%

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%

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%