[FONT="]I need to have a cell change color based on whether another cell is of greater value or lesser value. [/FONT]
[FONT="]Greater Green, lesser Red
The first number (1) would be neutral but then the next (2) would be green because its greater than and the next number (1) would be red because it dropped below the number (2) that proceeded it
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[/FONT]
[TABLE="width: 0"]
<colgroup><col style="width: 142px"><col width="100"><col width="100"><col width="100"><col width="100"><col width="100"><col width="100"></colgroup><tbody>[TR]
[TD="align: center"]Net Members [/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]0[/TD]
[/TR]
</tbody>[/TABLE]
[FONT="]TIA
✌?
?
?[/FONT]
[FONT="]Greater Green, lesser Red
The first number (1) would be neutral but then the next (2) would be green because its greater than and the next number (1) would be red because it dropped below the number (2) that proceeded it
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[/FONT]
[TABLE="width: 0"]
<colgroup><col style="width: 142px"><col width="100"><col width="100"><col width="100"><col width="100"><col width="100"><col width="100"></colgroup><tbody>[TR]
[TD="align: center"]Net Members [/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]0[/TD]
[/TR]
</tbody>[/TABLE]
[FONT="]TIA