Excel1: Conditional Formula:

[aacod]

I need a conditional formula in cell P3 such that:

1. if sum of cells K3:O3 - value in D3 = 0, format fonts to GREY

2. if sum of cells K3:O3 - value in D3 > 0, format fonts to GREEN

3. if sum of cells K3:O3 - value in D3 < 0, format fonts to RED

Thanks.

aacod

 

[bbott]

You would need three CFs since you want three colors, but you pretty much have it. They should look like:

=SUM(K3:O3)-D3=0

 

[aacod]

bbot,

I tried the same formula and I could not get the result, so I posted thinking that I may get help!

aacod

 

[bbott]

I used these three formulas and got the expected results:

=SUM(K3:O3)-D3<0
=SUM(K3:O3)-D3>0
=SUM(K3:O3)-D3=0

Is you worksheet calculation set to automatic or manual?

 

[aacod]

I have following formula in P3:
=IF(ISNUMBER(D3), (K3+L3+M3+N3+O3) - D3, "").

The figures in each cell from K3:O3 and manually entered.

aacod

 

[aacod]

I got it, created a new worksheet. Thanks.

 

[bbott]

I got it, created a new worksheet. Thanks.

You're welcome, glad you got it to work.