![]() |
#1
|
|||
|
|||
![]()
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. |
Tags |
paint |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
beginner | Excel | 2 | 12-03-2013 03:07 PM |
In Excel 2007-After Selecting Visibe Cells-How do I "Copy to Visible cells" Only | mag | Excel | 0 | 10-28-2012 08:04 PM |
![]() |
lostsoul62 | Excel | 5 | 10-17-2012 08:33 AM |
![]() |
zanat0s | Excel | 1 | 07-03-2012 04:27 AM |
Count range cells eliminating merge cells | danbenedek | Excel | 0 | 06-15-2010 12:40 AM |