Hi. I've read Chip Pearson's site on calculating based on color, but I'm not
savvy enough to copy it. Does the newer version and/or has anyone found a
easier workaround for identifying or calculating color?

Color is part of the format facility of Excel. It can be applied to font,
interior, lines and fill. If it is applied as conditional format it is at a
different level than if it is applied to the interior. It is not easy to
work with and Chip's code is about as simple as you are going to get.


"beata" <(E-Mail Removed)> wrote in message
news:711A6B19-427C-4DDB-890E-(E-Mail Removed)...
> Hi. I've read Chip Pearson's site on calculating based on color, but I'm
> not
> savvy enough to copy it. Does the newer version and/or has anyone found a
> easier workaround for identifying or calculating color?

Hi,
I have to agree with JLG here.
I've been using Chip's color by sum function for close to two years now, and
I swear by it.

If you're looking for an easier way to apply it, see my code for inserting
it into a cell below.....
This macro is formatted for use in my UIRibbon in Excel 2007.

Sub ColorSum(Control As IRibbonControl)
ActiveCell.FormulaR1C1 = "=sumbycolor(CellRange,ColorNum,TrueIfFontColor)"
With ActiveCell.Characters(Start:=1, Length:=150).Font
End With
End Sub

I then replace CellRange with a range of cells.
I replace ColorNum with the number of the color I'm using, and want summed.
And I either delete, or replace the TrueIfFontColor with the word "true"
depending on if I'm using font color as my format of choice.

I've gotta say--- this colorbysum function of Chip's is a very worthwhile
tool, and I use it regularly.
You'll be hard-pressed to find a better tool.



"beata" wrote:

> Hi. I've read Chip Pearson's site on calculating based on color, but I'm not
> savvy enough to copy it. Does the newer version and/or has anyone found a
> easier workaround for identifying or calculating color?

Thanks. It looked fairly straight forward and I did "download it" (I'm
ignorant but not timid) but I couldn't figure out how to "bring it in" or
"run it" or whatever one does to integrate it...

is it easy enough to explain on email?

"Steve" wrote:

> Hi,
> I have to agree with JLG here.
> I've been using Chip's color by sum function for close to two years now, and
> I swear by it.
>
> If you're looking for an easier way to apply it, see my code for inserting
> it into a cell below.....
> This macro is formatted for use in my UIRibbon in Excel 2007.
>
> Sub ColorSum(Control As IRibbonControl)
> ActiveCell.FormulaR1C1 = "=sumbycolor(CellRange,ColorNum,TrueIfFontColor)"
> With ActiveCell.Characters(Start:=1, Length:=150).Font
> End With
> End Sub
>
> I then replace CellRange with a range of cells.
> I replace ColorNum with the number of the color I'm using, and want summed.
> And I either delete, or replace the TrueIfFontColor with the word "true"
> depending on if I'm using font color as my format of choice.
>
> I've gotta say--- this colorbysum function of Chip's is a very worthwhile
> tool, and I use it regularly.
> You'll be hard-pressed to find a better tool.
>
>
>
> "beata" wrote:
>
> > Hi. I've read Chip Pearson's site on calculating based on color, but I'm not
> > savvy enough to copy it. Does the newer version and/or has anyone found a
> > easier workaround for identifying or calculating color?