JUL | AUG | SEP | OCT | NOV | DEC | |||||||||||||||||
FIELD 1 | FIELD 2 | FIELD 3 | FIELD 1 | FIELD 2 | FIELD 3 | FIELD 1 | FIELD 2 | FIELD 3 | FIELD 1 | FIELD 2 | FIELD 3 | FIELD 1 | FIELD 2 | FIELD 3 | FIELD 1 | FIELD 2 | FIELD 3 | |||||
-500 | -350 | 445 | -525 | -357 | 225 | -285 | -337 | 235 | -288 | -275 | 225 | 100 | 125 | 25 | 75 | 150 | 70 | |||||
250 | 225 | 25 | -100 | -75 | 25 | -225 | -235 | 10 | 75 | 150 | 75 | -150 | -200 | 50 | 25 | 50 | 25 | |||||
75 | 180 | 88 | -300 | -100 | 200 | -275 | -300 | 25 | -150 | -225 | 75 | 55 | 125 | 70 | -100 | 55 | 25 | |||||
-100 | -50 | 50 | 75 | 100 | 25 | 50 | 250 | 200 | -100 | -150 | 50 | -175 | -225 | 50 | -180 | -220 | 40 |
<tbody>
</tbody>
EDIT:
So question for the above:
I'm trying to conditional format this, to where for each row of data, it checks just the field 2's for each month, and if it sees 3+ consecutive NEGATIVE field 2's, then it will highlight the boxes in yellow.
So for the above example:
Row 1 (of data) should have JUL, AUG, SEP, OCT highlighted.
Row 2 nothing highlighted
Row 3 AUG, SEP, OCT
Row 4 OCT, NOV, DEC
Last edited by a moderator: