Count if font color..

[Murph]

Can excel sum certain cells according to font color?

i.e. cash back expenses listed in red - summed to cell E4
credit card purchases listed in blue - sum to cell F4

the user manipulates the font color during input. But all values are listed
in a Mon-Fri G1-K1 area

[Bob Phillips]

See http://www.xldynamic.com/source/xld.ColourCounter.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Murph" <[email protected]> wrote in message
news:[email protected]...
> Can excel sum certain cells according to font color?
>
> i.e. cash back expenses listed in red - summed to cell E4
> credit card purchases listed in blue - sum to cell F4
>
> the user manipulates the font color during input. But all values are
listed
> in a Mon-Fri G1-K1 area
>
>

[Dnereb]

Can excel sum certain cells according to font color?

i.e. cash back expenses listed in red - summed to cell E4
credit card purchases listed in blue - sum to cell F4

the user manipulates the font color during input. But all values are listed
in a Mon-Fri G1-K1 area

Not as a command but you can write a function to do it for you in VBA

like:

Please Login or Register  to view this content.