View Single Post
 
Old 03-06-2014, 06:57 AM
zizao zizao is offline Windows Vista Office 2007
Novice
 
Join Date: Mar 2014
Posts: 4
zizao is on a distinguished road
Default Painting cells whose sum is zero

I'm from Brazil and I need your help to solve a spreadsheet.

I have the following values:



8881.92
-6,735.58
-196546.73
-10,229.00
-6,003.60
-69.60
211,632.56
-2,878.32
-4,856.83
-137.24
-8,031.08



I need to paint the cells whose sum is zero.

Note that 8881.92 + - 6003.60 + - 2878.32 = zero
and - 196,546.73 + 211,632.56 + - 10,229.00 + - 4856.83 = zero


So I need formula or macro to paint those cells whose sum is zero, so:



8881.92
-6,735.58
-196546.73
-10,229.00
-6,003.60

-69.60
211,632.56
-2,878.32
-4,856.83

-137.24
-8,031.08



Spreadsheet with real data: download


Thanks in advance.

Last edited by zizao; 03-07-2014 at 05:15 AM.
Reply With Quote