Results 1 to 3 of 3

Thread: Painting cells whose sum is zero

  1. #1

    Painting cells whose sum is zero



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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




    Thanks in advance.

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,437
    Articles
    0
    Excel Version
    Excel 2016
    Please post links to all crosspostings of this topic in other forums.


  3. #3
    excelguru.ca, excelforum, ozgrid and mrexcel.com

    Kaper found the solution in EXCELFORUM. The solution are attached to this message.
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •