Conditional Formatting - Updating Cell References

Hello again,

I have a series of data running from cell W2-W32. I have another series of data (same number of data points) running from Cell W38-68. I want to set up a conditional format on cells W2-W32 where if the value in any cell from W2-W32 is greater than the value in the corresponding cell for W38-W68 + .03 ==> highlight cell red.


What I have now:

=IF($W$2:$W$32>($W$38:$W$68+0.03),TRUE,FALSE)

the above is not working for me.

When I use the same formula, but apply it only to a single cell, it works perfectly fine.

My guess is it has something to do with the cell references not updating properly.

Your thoughts?

Apply the conditional format to cell W2 using this formula with relative references:

Please Login or Register  to view this content.

Then use the format paintbrush to copy the format to the other cells in W2:W32.

Cheers,