Forum Discussion
Conditional Formatting - Based on range of values
Hello, I have a list of values in Column R and another list of values in Column S. I would like to use conditional formatting on Column S only if the value is greater than a 0.20 difference from ...
Hi Sergei,
Isn't the formula you provided trying to figure out if it's greater than 20% of R1? Column R and Column S are both currencies, so I need to know if there is 20 cents or greater difference between the 2 cells. This can be 20 cents more or 20 cents less.
That was 20%. I guess the difference in 20 cents or more will be simply
=ABS($R2-$S2)>=0.2
This worked, thank you