the base value is: =IF(AND(Sheet2!C30>249,Sheet2!C30<500),"True","") the conditional formatting will highlight the cell red if true. |

=IF(AND(Sheet2!C30>499,Sheet2!C30<750,),"True","")

the problem comes in when the sum increases say to 600 the initial value turns false and then only one value is highlighted instead of them stacking and the base remaining highlighted as well. Boy I sure hope someone can understand what I am trying to accomplish. Thank you.