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 Column R. I've tried a few different formulas but nothing seems to be working for me. Please let me know if you need clarification. I manually highlighted an example of cells where I would want the one column to have a red font.
Thank you!
Hi Monica,
Other words you'd like to highlight the cells where
=ABS($R1-$S1)>0.2*$R1
If so add this rule to conditional formatting and apply it to your range
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
