+ Reply to Thread
Results 1 to 1 of 1

Help needed! sumifs with condition of font color

  1. #1
    Registered User
    Join Date
    01-15-2015
    Location
    usa
    MS-Off Ver
    2013
    Posts
    1

    Help needed! sumifs with condition of font color

    I'm new here and need your help.
    I have to use sumifs in macro for two conditions, one condition is based on font color. ( sum total based on both text and font color)
    is there a way of defining font color index as condition criteria for sumifs?

    thanks very much

    2011 2012 2013
    a 55 55 55
    a 1 2 3
    b 2 4 6


    2011
    TotalBlue a 55
    TotalBrown a 1
    TotalBrown b 2
    Last edited by Yunna; 01-15-2015 at 12:00 PM.

+ 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. [SOLVED] Formula to highlight cell (or change font color) when condition is met
    By Maezee in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-20-2013, 04:17 PM
  2. Replies: 2
    Last Post: 02-04-2013, 02:00 PM
  3. Change font color based on font color of another cell
    By Ibyers in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2012, 09:36 AM
  4. Change the color of the font in a cell under a condition.
    By Quiltface in forum Excel General
    Replies: 1
    Last Post: 11-06-2009, 02:36 PM
  5. [SOLVED] Event Macro adjustment needed - need to change font color also
    By nick s in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-28-2005, 01:55 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