Here is my current formula:
=SUMPRODUCT((Commissions!$J$2:$J$1946=$A31)*(Commissions!$B$2:$B$1946>='Pay
Day'!$A$2)*(Commissions!$B$2:$B$1946<='Pay
Day'!$B$2),Commissions!$G$2:$G$1946)*'Pay Day'!$B$31

I want to be able to turn the cell color RED if the final clause equals
*'Pay Day'!$B$32. If i over-ride my current formula above with the new
ending how can I change my cell color?

Any help is greatly appreciated. Thank you