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?
Test spreadsheet located here: https://docs.google.com/
No comments:
Post a Comment