Conditional Formattign in Excel

[#1]

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.

Thanks for any and all help.

Best.

[#2]

I figured it out, if I want to compare the outcome of B1 - C1 for B1:C50, then within the Conditional Formatting Rules Manager you cannot hard code =($B$1-$C$1)<0, nor =($B$1:$B$50-$C$1:$C$50)<0, but rather =($B1-$C1) < 0, to keep the calculations in column $B and $C. This will then calculate B1 - C1 .......... B50 - C50, and if < 0, will format the cells RED, then you need to create an additional Rule that states  =($B1-$C1) >= 0, to format the cells GREEN.

Best

[sinanozdemir · Accepted solution]

Just use VBA, please see below screenshot:

[#4]

no harm no foul

[#5]

Much easier, thanks mate

[sinanozdemir]

You are welcome.