Is there any way to create a dynamic IF() statement within Excel that will color cells based on their sum. Thus I want a formula that simply states that is B1 - C1 > 0, Green(), Red(), and I want it applied to $B$1:$C$50. Is this possible? I am comparing the computed value for each row and thus will color the cell accordingly.
I know that, however, I need help with the IF() statement itself, because I am not simply comparing all cell values to a single value, but rather the product of Cell 1 - Cell 2, which will then determine what color each cell should be.