Conditional Formatting, 1 Column greater than the other

[Apprentice35]

Hi all,

I'm doing some analysis of data from two measurement systems, I want to see if the two processes are getting results within 10% of the allowed tolerance.

The below link is what I'm dealing with in excel.

Imgur: The most awesome images on the Internet

I'd like to use conditional formatting to change the 'status' column to go red if the value in D2 is greater than the value in G2, I managed to do this for row2, but couldn't get it to go down the entire data set, without creating a rule for each row (i don't want to do this as I have 850+ lines of data to check).

I've searched online and found a few answer but they all only seemed to check the first row, or they didn't include a third column like I want to.

Hope I explained that clearly, any help is appreciated.

 

[James006]

Glad you have managed to master this problem ...