Conditional Formatting

[jevi]

Hi All,

I would like to have a formula for doing conditional formatting only in the columns Delta but it is tricky as in the first row:

Delta1 = data2- data1
Delta2= data3 - data2
Delta3= data4 - data3

So in the first row of delta1: 12-10=2 and I need this case do be red as an increment is not good.
in the second row of delta1: 41 - 43= -2 and I need this cell/case to be green as it is improving.
in the third row of delta1: 0 - 0 = 0 and I need this cell to be green as it has nothing to do as it is zero.

but and here is the tricky one:

Row1 but Delta2 = 12 - 12=0 I need this cell to be red as it not improving the situation. They have a stock of questionaries and they need to finish them and not increment the number but also keeping the same number is not good.

I hope I was clear with my explanation

Thank you so much,

 

[Fluff]

Assuming Delta1 is col D
for -ve numbers use =D2<0
for +ve numbers use =D2>0
for green 0s use =AND(C2=0,D2=0)
and for red 0s =AND(C2<>0,D2=0)

 

[jevi]

Assuming Delta1 is col D
for -ve numbers use =D2<0
for +ve numbers use =D2>0
for green 0s use =AND(C2=0,D2=0)
and for red 0s =AND(C2<>0,D2=0)

Hi Pluff,

it worked great....I did put all 4 formulas in the conditional formatting and they worked with all the cases I have.

Thank you so much.

 

[Fluff]

You're welcome & thanks for the feedback.