+ Reply to Thread
Results 1 to 2 of 2

How to Total a Column That Contains Conditional Formatting

  1. #1
    Registered User
    Join Date
    09-03-2015
    Location
    Prairieville, LA
    MS-Off Ver
    2013 Windows
    Posts
    3

    How to Total a Column That Contains Conditional Formatting

    I have a 4 page worksheet and based upon the answers that are provided on page 1 I have set up conditional formatting on pages 2, 3, and 4 to highlight a cell if it meets the criteria from page 1. Now I need the highlighted cells to total at the bottom of each page on pages 2, 3, and 4. Is this possible?

    Here is a sample scenario:
    If M1324 is answered with a 1 on page 1 and it is an early episode with <13 therapy visits then a score of 3 would be highlighted on page 2.
    =IF(AND('Page 1'!$H$11>=2,'Page 1'!$H$6="Early",'Page 1'!$H$29<=13),$D$42," ")

    If M1334 is answered with a 2 on page 1 and it is a late episode with <13 therapy visits then a score of 8 would be highlighted on page 2.
    =IF(AND('Page 1'!$H$16=2,'Page 1'!$H$6="Later",'Page 1'!$H$29<=13),$F$45," ")

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: How to Total a Column That Contains Conditional Formatting

    To sum cells that are highlighted by conditional formatting, you have to use a SUMIF or SUMIFS formula that parallels the conditional formatting rule. (There is no way to say "sum all cells that are currently highlighted with conditional formatting", not even in a macro).

    I have no idea what you mean by M1324 or M1334, where these formulas appear, or how they relate to your conditional formatting.

    Of course, the best thing would be to attach your file with sample data and point out exactly where you want the sums to appear and what cells are to be included in the sums.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. conditional formatting for running total
    By ammartino44 in forum Excel General
    Replies: 8
    Last Post: 05-11-2015, 05:38 PM
  2. [SOLVED] Conditional Formatting To Reference a String in a Column and Applied to another Column
    By ABC2014 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-21-2014, 08:25 PM
  3. Replies: 1
    Last Post: 05-19-2013, 06:40 PM
  4. Conditional Formatting a Running Total
    By dwalinga in forum Excel General
    Replies: 0
    Last Post: 03-19-2013, 10:25 AM
  5. Running Total with Conditional Formatting and no Repeats
    By Gwen@YouWantWhat? in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-15-2012, 01:19 PM
  6. Replies: 5
    Last Post: 09-24-2012, 05:14 PM
  7. conditional formatting total
    By Tiya in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-01-2005, 04:05 AM

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