+ Reply to Thread
Results 1 to 2 of 2

Adding value of colored cells (conditional formatting)

  1. #1
    Registered User
    Join Date
    05-28-2016
    Location
    Australia
    MS-Off Ver
    2013
    Posts
    88

    Adding value of colored cells (conditional formatting)

    I have a range of cells (G9:G13 and G16:20) that change color based on conditional formatting rules i have in place.
    These same cells already return a result from a complex formula I am happy with.
    They will be white unless triggered to turn one of three colors.

    When any of them change color I want to be able to add the value in those colored cells together, but in a different cell.

    If 4 red cells have the value 8 in then I want the end result (32) to be in cell G33
    If 1 blue cell has a 2 then another blue cell has 5 i want the end result (7) to be in cell G34
    If 2 green cells have a 3 then another green cell has 12 i want the end result (18) to be in cell G35

    (I want to be able to choose any color or formatting, not just the examples above.)

    no white (default) cells will be added together at all.

    I found this vba script but wasn't sure if it was appropriate.
    https://www.ablebits.com/office-addi...y-color-excel/


    Any suggestions? This one is beyond me but I'm sure its possible.
    Thanks ahead of time.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    31,246

    Re: Adding value of colored cells (conditional formatting)

    Why don't you just use SUMIFS with the same conditions you used to colour the cells?
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 01-19-2016, 10:24 PM
  2. [SOLVED] Count colored cells for conditional formatting
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-08-2015, 05:52 AM
  3. Replies: 4
    Last Post: 07-18-2015, 11:13 AM
  4. Replies: 1
    Last Post: 11-09-2013, 02:43 AM
  5. Count Cells colored by conditional formatting
    By sam99 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-19-2013, 02:58 PM
  6. [SOLVED] Conditional Formatting with Colored Arrows
    By garrett.grillo in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-21-2013, 09:24 PM
  7. conditional formatting and colored cells
    By henro8 in forum Excel General
    Replies: 9
    Last Post: 07-10-2008, 03:12 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1