sean.golds
07-17-2017, 07:40 AM
I have an excel spreadsheet, using only one worksheet within which I need to compare two numerical values, located 2 rows apart within the same column for a specific change in the following way (the following isn't an attempt at code, just my description of what I need):
Column 7 (G) Row 2 (B) to be compared against Column 7 (G) Row 4 (D) If Row 4 value is < Row 2, highlight in red
Then move to Column 7 (G) Row 4 (D) and compare against Column 7 (G) Row 6 (F) If Row 6 value is < Row 4, highlight in red
Repeat this process until we reach a blank row.
Any help would be appreciated.
Thanks
Column 7 (G) Row 2 (B) to be compared against Column 7 (G) Row 4 (D) If Row 4 value is < Row 2, highlight in red
Then move to Column 7 (G) Row 4 (D) and compare against Column 7 (G) Row 6 (F) If Row 6 value is < Row 4, highlight in red
Repeat this process until we reach a blank row.
Any help would be appreciated.
Thanks