Greetings,

I have a Conditional Format with a couple of SUMIF's in it, The SUMIF
does not seem to notice the polarity of the numbers it is summing and
is giving erroneous results. Example: if the data in the selected
rows and 1st referenced column are 10, 120, 20, -180 and 40. The
result should be 10. It should match up with the 2nd summed column
which has only a 10. They do not! The formula works if all numbers
are positive. Here are the formulas in the Conditional Format:

2nd conditional formula:

=(SUMIF($X$2:$X$250,$X2,$E$2:$E$250)-SUMIF($X$2:$X$250,$X2,$F$2:$F$250))0
Turns cell pink

3rd conditional formula:

=(SUMIF($X$2:$X$250,$X2,$F$2:$F$250)-SUMIF($X$2:$X$250,$X2,$E$2:$E$250))0
Turns cell light blue

Column X is the reference column. Column E is first column summed and
Column F is last column summed. The totals of summed column E are
supposed to equal the summed totals of column F for any given value in
column X.

That is what it is doing except for any negative numbers.

Is there any way to fix this?

Any help would be most appreciated.

-TIA

-Minitman