Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Mar 2003
    Location
    Toronto, Ontario, Canada
    Posts
    94
    Thanks
    0
    Thanked 0 Times in 0 Posts

    SUMIF based on font color (XP)

    Is it possible to perform a sumif function based on the font color. There is no other tell-tale sign that these numbers need to be added up, other than the fact that I've highlighted them in red.

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: SUMIF based on font color (XP)

    Not built-in but it can be done with vba. See Chip Pearson's Site

Posting Permissions

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