Tuesday, May 1, 2018

yogi_Conditionally Format Cells Based on Absolute Value Difference to Another Cell

Google Spreadsheet   Post  #2442

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     May-01-2018

question by: Chadillac
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/wgkg8WHMowI;context-place=forum/docs
Conditional Formatting Based on Absolute Value Difference to Another Cell
I'm wondering if it is possible to create custom conditional formatting of a cell based on its absolute value difference from another cell. In the spreadsheet linked below, for example, I would like to have B13 and B14 change color to indicate their difference between each other is greater than 1.

For context: these are essay scores that have been assessed twice by readers, so each "Essay ID" corresponds to the pair of scores each essay has received. I'm hoping to create custom conditional formatting that would highlight where reader scores vary by more than 1 for each column B through H. Is this possible?