[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]JUL[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]AUG[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]SEP[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]OCT[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]NOV[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]DEC[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]FIELD 1[/TD]
[TD="align: center"]FIELD 2[/TD]
[TD="align: center"]FIELD 3[/TD]
[TD="align: center"][/TD]
[TD="align: center"]FIELD 1[/TD]
[TD="align: center"]FIELD 2[/TD]
[TD="align: center"]FIELD 3[/TD]
[TD="align: center"][/TD]
[TD="align: center"]FIELD 1[/TD]
[TD="align: center"]FIELD 2[/TD]
[TD="align: center"]FIELD 3[/TD]
[TD="align: center"][/TD]
[TD="align: center"]FIELD 1[/TD]
[TD="align: center"]FIELD 2[/TD]
[TD="align: center"]FIELD 3[/TD]
[TD="align: center"][/TD]
[TD="align: center"]FIELD 1[/TD]
[TD="align: center"]FIELD 2[/TD]
[TD="align: center"]FIELD 3[/TD]
[TD="align: center"][/TD]
[TD="align: center"]FIELD 1[/TD]
[TD="align: center"]FIELD 2[/TD]
[TD="align: center"]FIELD 3[/TD]
[/TR]
[TR]
[TD="align: center"]-500[/TD]
[TD="align: center"]-350[/TD]
[TD="align: center"]445[/TD]
[TD="align: center"][/TD]
[TD="align: center"]-525[/TD]
[TD="align: center"]-357[/TD]
[TD="align: center"]225[/TD]
[TD="align: center"][/TD]
[TD="align: center"]-285[/TD]
[TD="align: center"]-337[/TD]
[TD="align: center"]235[/TD]
[TD="align: center"][/TD]
[TD="align: center"]-288[/TD]
[TD="align: center"]-275[/TD]
[TD="align: center"]225[/TD]
[TD="align: center"][/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]125[/TD]
[TD="align: center"]25[/TD]
[TD="align: center"][/TD]
[TD="align: center"]75[/TD]
[TD="align: center"]150[/TD]
[TD="align: center"]70[/TD]
[/TR]
[TR]
[TD="align: center"]250[/TD]
[TD="align: center"]225[/TD]
[TD="align: center"]25[/TD]
[TD="align: center"][/TD]
[TD="align: center"]-100[/TD]
[TD="align: center"]-75[/TD]
[TD="align: center"]25[/TD]
[TD="align: center"][/TD]
[TD="align: center"]-225[/TD]
[TD="align: center"]-235[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"][/TD]
[TD="align: center"]75[/TD]
[TD="align: center"]150[/TD]
[TD="align: center"]75[/TD]
[TD="align: center"][/TD]
[TD="align: center"]-150[/TD]
[TD="align: center"]-200[/TD]
[TD="align: center"]50[/TD]
[TD="align: center"][/TD]
[TD="align: center"]25[/TD]
[TD="align: center"]50[/TD]
[TD="align: center"]25[/TD]
[/TR]
[TR]
[TD="align: center"]75[/TD]
[TD="align: center"]180[/TD]
[TD="align: center"]88[/TD]
[TD="align: center"][/TD]
[TD="align: center"]-300[/TD]
[TD="align: center"]-100[/TD]
[TD="align: center"]200[/TD]
[TD="align: center"][/TD]
[TD="align: center"]-275[/TD]
[TD="align: center"]-300[/TD]
[TD="align: center"]25[/TD]
[TD="align: center"][/TD]
[TD="align: center"]-150[/TD]
[TD="align: center"]-225[/TD]
[TD="align: center"]75[/TD]
[TD="align: center"][/TD]
[TD="align: center"]55[/TD]
[TD="align: center"]125[/TD]
[TD="align: center"]70[/TD]
[TD="align: center"][/TD]
[TD="align: center"]-100[/TD]
[TD="align: center"]55[/TD]
[TD="align: center"]25[/TD]
[/TR]
[TR]
[TD="align: center"]-100[/TD]
[TD="align: center"]-50[/TD]
[TD="align: center"]50[/TD]
[TD="align: center"][/TD]
[TD="align: center"]75[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]25[/TD]
[TD="align: center"][/TD]
[TD="align: center"]50[/TD]
[TD="align: center"]250[/TD]
[TD]200[/TD]
[TD][/TD]
[TD]-100[/TD]
[TD]-150[/TD]
[TD]50[/TD]
[TD][/TD]
[TD]-175[/TD]
[TD]-225[/TD]
[TD]50[/TD]
[TD][/TD]
[TD]-180[/TD]
[TD]-220[/TD]
[TD]40[/TD]
[/TR]
</tbody>[/TABLE]
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
<tbody>[TR]
[TD][/TD]
[TD="align: center"]JUL[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]AUG[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]SEP[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]OCT[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]NOV[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]DEC[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]FIELD 1[/TD]
[TD="align: center"]FIELD 2[/TD]
[TD="align: center"]FIELD 3[/TD]
[TD="align: center"][/TD]
[TD="align: center"]FIELD 1[/TD]
[TD="align: center"]FIELD 2[/TD]
[TD="align: center"]FIELD 3[/TD]
[TD="align: center"][/TD]
[TD="align: center"]FIELD 1[/TD]
[TD="align: center"]FIELD 2[/TD]
[TD="align: center"]FIELD 3[/TD]
[TD="align: center"][/TD]
[TD="align: center"]FIELD 1[/TD]
[TD="align: center"]FIELD 2[/TD]
[TD="align: center"]FIELD 3[/TD]
[TD="align: center"][/TD]
[TD="align: center"]FIELD 1[/TD]
[TD="align: center"]FIELD 2[/TD]
[TD="align: center"]FIELD 3[/TD]
[TD="align: center"][/TD]
[TD="align: center"]FIELD 1[/TD]
[TD="align: center"]FIELD 2[/TD]
[TD="align: center"]FIELD 3[/TD]
[/TR]
[TR]
[TD="align: center"]-500[/TD]
[TD="align: center"]-350[/TD]
[TD="align: center"]445[/TD]
[TD="align: center"][/TD]
[TD="align: center"]-525[/TD]
[TD="align: center"]-357[/TD]
[TD="align: center"]225[/TD]
[TD="align: center"][/TD]
[TD="align: center"]-285[/TD]
[TD="align: center"]-337[/TD]
[TD="align: center"]235[/TD]
[TD="align: center"][/TD]
[TD="align: center"]-288[/TD]
[TD="align: center"]-275[/TD]
[TD="align: center"]225[/TD]
[TD="align: center"][/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]125[/TD]
[TD="align: center"]25[/TD]
[TD="align: center"][/TD]
[TD="align: center"]75[/TD]
[TD="align: center"]150[/TD]
[TD="align: center"]70[/TD]
[/TR]
[TR]
[TD="align: center"]250[/TD]
[TD="align: center"]225[/TD]
[TD="align: center"]25[/TD]
[TD="align: center"][/TD]
[TD="align: center"]-100[/TD]
[TD="align: center"]-75[/TD]
[TD="align: center"]25[/TD]
[TD="align: center"][/TD]
[TD="align: center"]-225[/TD]
[TD="align: center"]-235[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"][/TD]
[TD="align: center"]75[/TD]
[TD="align: center"]150[/TD]
[TD="align: center"]75[/TD]
[TD="align: center"][/TD]
[TD="align: center"]-150[/TD]
[TD="align: center"]-200[/TD]
[TD="align: center"]50[/TD]
[TD="align: center"][/TD]
[TD="align: center"]25[/TD]
[TD="align: center"]50[/TD]
[TD="align: center"]25[/TD]
[/TR]
[TR]
[TD="align: center"]75[/TD]
[TD="align: center"]180[/TD]
[TD="align: center"]88[/TD]
[TD="align: center"][/TD]
[TD="align: center"]-300[/TD]
[TD="align: center"]-100[/TD]
[TD="align: center"]200[/TD]
[TD="align: center"][/TD]
[TD="align: center"]-275[/TD]
[TD="align: center"]-300[/TD]
[TD="align: center"]25[/TD]
[TD="align: center"][/TD]
[TD="align: center"]-150[/TD]
[TD="align: center"]-225[/TD]
[TD="align: center"]75[/TD]
[TD="align: center"][/TD]
[TD="align: center"]55[/TD]
[TD="align: center"]125[/TD]
[TD="align: center"]70[/TD]
[TD="align: center"][/TD]
[TD="align: center"]-100[/TD]
[TD="align: center"]55[/TD]
[TD="align: center"]25[/TD]
[/TR]
[TR]
[TD="align: center"]-100[/TD]
[TD="align: center"]-50[/TD]
[TD="align: center"]50[/TD]
[TD="align: center"][/TD]
[TD="align: center"]75[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]25[/TD]
[TD="align: center"][/TD]
[TD="align: center"]50[/TD]
[TD="align: center"]250[/TD]
[TD]200[/TD]
[TD][/TD]
[TD]-100[/TD]
[TD]-150[/TD]
[TD]50[/TD]
[TD][/TD]
[TD]-175[/TD]
[TD]-225[/TD]
[TD]50[/TD]
[TD][/TD]
[TD]-180[/TD]
[TD]-220[/TD]
[TD]40[/TD]
[/TR]
</tbody>[/TABLE]
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: