+ Reply to Thread
Results 1 to 4 of 4

Highlight cells where total sum > average in another column

  1. #1
    Forum Contributor
    Join Date
    12-18-2011
    Location
    long island
    MS-Off Ver
    365
    Posts
    236

    Highlight cells where total sum > average in another column

    Hello,

    I'm trying to write a macro that highlights cells where the sum of the cells are greater than the average of cells in a different column.
    For example on the attached sheet, if A1 > avg B1:B10, highlight. If not, is A1 + A2 > avg B1:B10,, and so on until the condition is met.

    Thank You
    Attached Files Attached Files

  2. #2
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,082

    Re: Highlight cells where total sum > average in another column

    Try this macro

    Please Login or Register  to view this content.
    Happy with my advice? Click on the * reputation button below

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Highlight cells where total sum > average in another column

    Conditional formatting.
    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    12-18-2011
    Location
    long island
    MS-Off Ver
    365
    Posts
    236

    Re: Highlight cells where total sum > average in another column

    Thank You!
    Macro works great!
    Last edited by phbryan; 06-03-2021 at 08:42 AM.

+ 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: 2
    Last Post: 10-30-2020, 05:54 PM
  2. [SOLVED] Highlight column of numbers and get total
    By jerryeteo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-29-2016, 01:42 PM
  3. highlight cells being discarded from average
    By jimboryan in forum Excel General
    Replies: 4
    Last Post: 08-26-2014, 05:44 PM
  4. [SOLVED] Total and Average where name in column 1 is the same
    By Astamil in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-07-2012, 01:40 PM
  5. Replies: 2
    Last Post: 05-27-2012, 06:10 AM
  6. When i highlight cells, I USED to get total in bottom rt corner?
    By Barb B in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-08-2006, 09:10 AM
  7. [SOLVED] highlight cells to obtain total without using formula?
    By rdavia in forum Excel General
    Replies: 2
    Last Post: 01-18-2005, 02:06 PM

Tags for this Thread

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