Conditional formatting

[lasty48]

Hello

I have a spreadsheet where i have applied some conditional formatting. Where if A2 - B2 = X and X is = +/- 2 its green, if its between = +/-4 its yellow and if its greater than 4 its red. This part i have running nicely down my page A3-B3 etc etc.

but what i now want to do is if the difference between X1 and X2 is greater than 4 i want it fill X2 as red even if it was or should be green from the original CF above, if not than keep it the orginal colour, then work on the difference bewteen x2 and x3 etc down the column.

Cheers

Lasty

 

[Special-K99]

4 conditions required.
In this order with "Stop if condition is true" ticked

=(X2-X1 > 4)
format as red for X2
=ABS(A2-B2 > 4)
format as yellow
=ABS(A2-B2 > 2)
format as red
=ABS(A2-B2 < 2)
format as green