+ Reply to Thread
Results 1 to 2 of 2

I have cells with diffent color fonts and need to total based on .

  1. #1
    KyaraB
    Guest

    I have cells with diffent color fonts and need to total based on .

    I need to total a range of cells in excel based on the font color. I assume
    this would be done with an "IF" statement but how do I word it?
    I want to total cell range C8 to AG8 but only if the font color is Blue.


  2. #2
    JulieD
    Guest

    Re: I have cells with diffent color fonts and need to total based on .

    Hi Kyara

    this is not possible without using VBA ... see
    http://www.cpearson.com/excel/SortByColor.htm for details.

    --
    Cheers
    JulieD
    check out www.hcts.net.au/tipsandtricks.htm
    ....well i'm working on it anyway
    "KyaraB" <KyaraB@discussions.microsoft.com> wrote in message
    news:ACF1C4EC-9B0F-4A5A-9502-025993906CDE@microsoft.com...
    >I need to total a range of cells in excel based on the font color. I assume
    > this would be done with an "IF" statement but how do I word it?
    > I want to total cell range C8 to AG8 but only if the font color is Blue.
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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