Conditional Formatting Multiple Columns
 

I am comparing two sets of numbers and would like to format the cell if the
difference is within a certain range - as follows (where ABC and HIJ are the
columns, Length Width Height are in Row 1):

A B C
Length Width Height
12.9 11.0 4.0
7.3 7.0 4.8
23.5 3.5 3.5
12.8 11.0 6.0

H I J
Length Width Height
12.90 10.92 5.58
7.60 7.00 5.10
23.30 3.60 3.60
12.20 9.90 4.60

When the difference between H2 and A2 is .5 (positive or negative) I would
like to shade the cell in H, I, or J. In the above example, J2 would be
shaded, H2 and I2 would not and so on.

I'm not sure how to capture the variance.

Can this be acheived using conditional formatting?
Thanks in Advance!

Conditional Formatting Multiple Columns
 

I think you actaully meant to say "if the variance is greater than 0.5" Put
this conditional format into H2

Formula is:
=ABS(H2-A2)=0.5

Select H2, Copy, then select all your other cells you want formatted.
Right-click, paste special, formatting only.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"JessP27" wrote:

I am comparing two sets of numbers and would like to format the cell if the
difference is within a certain range - as follows (where ABC and HIJ are the
columns, Length Width Height are in Row 1):

A B C
Length Width Height
12.9 11.0 4.0
7.3 7.0 4.8
23.5 3.5 3.5
12.8 11.0 6.0

H I J
Length Width Height
12.90 10.92 5.58
7.60 7.00 5.10
23.30 3.60 3.60
12.20 9.90 4.60

When the difference between H2 and A2 is .5 (positive or negative) I would
like to shade the cell in H, I, or J. In the above example, J2 would be
shaded, H2 and I2 would not and so on.

I'm not sure how to capture the variance.

Can this be acheived using conditional formatting?
Thanks in Advance!

Conditional Formatting Multiple Columns
 

Luke,
This didn't seem to work. I tried a couple of variations and each one has a
different result.
You are correct - I am trying to note a "variance greater than .5"

Any other suggestions?
Thanks,
Jessica

"Luke M" wrote:

I think you actaully meant to say "if the variance is greater than 0.5" Put
this conditional format into H2

Formula is:
=ABS(H2-A2)=0.5

Select H2, Copy, then select all your other cells you want formatted.
Right-click, paste special, formatting only.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"JessP27" wrote:

I am comparing two sets of numbers and would like to format the cell if the
difference is within a certain range - as follows (where ABC and HIJ are the
columns, Length Width Height are in Row 1):

A B C
Length Width Height
12.9 11.0 4.0
7.3 7.0 4.8
23.5 3.5 3.5
12.8 11.0 6.0

H I J
Length Width Height
12.90 10.92 5.58
7.60 7.00 5.10
23.30 3.60 3.60
12.20 9.90 4.60

When the difference between H2 and A2 is .5 (positive or negative) I would
like to shade the cell in H, I, or J. In the above example, J2 would be
shaded, H2 and I2 would not and so on.

I'm not sure how to capture the variance.

Can this be acheived using conditional formatting?
Thanks in Advance!