samedi 6 août 2016

Excel: How to highlight cells if the neighboring cell value differs by 2 or more?

I have several hundred rows of data in sets of two rows. Each row has ratings from 1-5. I need to highlight the cells when they differ by more than 1.

For example if one cell has a "4" and the cell below it is "3" or "5" that is ok. If one cell has a "4" but the cell below it has a "1,"2," or "5," both of those cells need to be highlighted.

I have looked into using conditional formating but this does not help because I can only enter rules asking to highlight < or >, not specific differences of 2 or more.

Background: The data is two sets of subjective ratings of videos of an autistic patient using psychological measures. If one rater differs from the other rater in scoring by more than "1," the data needs to be highlighted so the scoring for that measure can be discussed.

The picture is how the data should look like (not actual data file): http://ift.tt/2aZJHBX

Thank you!!

Aucun commentaire:

Enregistrer un commentaire