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%