I can't find this answer anywhere on the internet, so maybe I need to do it a different way.
I want to compare current month cell to prior month cell as a percentage (AC5) AND greater than an ABS dollar amount (AB5). I have the formula below which I created in excel 2003, but I can't get it to work in excel 2010.
I can get each piece to work individually, but not all three together. I only want conditional formatting returned if the current cell is greater or less than the percent I put in AC5 AND greater than the dollar amount I put in AB5.
<TABLE style="WIDTH: 386pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=515 border=0><COLGROUP><COL style="WIDTH: 60pt" span=3 width=80><COL style="WIDTH: 71pt; mso-width-source: userset; mso-width-alt: 2702" width=95><COL style="WIDTH: 75pt; mso-width-source: userset; mso-width-alt: 2844" width=100><COL style="WIDTH: 60pt" width=80><TBODY><TR style="HEIGHT: 45.75pt; mso-height-source: userset" height=61><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 386pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 45.75pt; BACKGROUND-COLOR: transparent" width=515 colSpan=6 height=61>AND(OR(current mth cell > (1+$AC$5)* Prior month cell), current month cell < (1-$AC$5)*Pr mth cell), ABS (current mnth cell - prior mth cell >$AB$5)
I am highlighting the entire range I want to be conditionally formatted and entering in the above formula and it doesn't highlight anything. What am I donig wrong?
</TD></TR></TBODY></TABLE>
I want to compare current month cell to prior month cell as a percentage (AC5) AND greater than an ABS dollar amount (AB5). I have the formula below which I created in excel 2003, but I can't get it to work in excel 2010.
I can get each piece to work individually, but not all three together. I only want conditional formatting returned if the current cell is greater or less than the percent I put in AC5 AND greater than the dollar amount I put in AB5.
<TABLE style="WIDTH: 386pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=515 border=0><COLGROUP><COL style="WIDTH: 60pt" span=3 width=80><COL style="WIDTH: 71pt; mso-width-source: userset; mso-width-alt: 2702" width=95><COL style="WIDTH: 75pt; mso-width-source: userset; mso-width-alt: 2844" width=100><COL style="WIDTH: 60pt" width=80><TBODY><TR style="HEIGHT: 45.75pt; mso-height-source: userset" height=61><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 386pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 45.75pt; BACKGROUND-COLOR: transparent" width=515 colSpan=6 height=61>AND(OR(current mth cell > (1+$AC$5)* Prior month cell), current month cell < (1-$AC$5)*Pr mth cell), ABS (current mnth cell - prior mth cell >$AB$5)
I am highlighting the entire range I want to be conditionally formatted and entering in the above formula and it doesn't highlight anything. What am I donig wrong?
</TD></TR></TBODY></TABLE>
