Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-06-2014, 06:57 AM
zizao zizao is offline Painting cells whose sum is zero Windows Vista Painting cells whose sum is zero Office 2007
Novice
Painting cells whose sum is zero
 
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
 

Tags
paint



Similar Threads
Thread Thread Starter Forum Replies Last Post
Painting cells whose sum is zero Sum up cells 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
Painting cells whose sum is zero Un even cells lostsoul62 Excel 5 10-17-2012 08:33 AM
Painting cells whose sum is zero How-TO format cells (FILL) by comparing cells zanat0s Excel 1 07-03-2012 04:27 AM
Count range cells eliminating merge cells danbenedek Excel 0 06-15-2010 12:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:08 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft