sumif and colored fonts..

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Murph - 15 Aug 2005 20:40 GMT

can Excel sum colored fonts?

grouping of currency figures in cells A1-F1
can excel sum on the the red fonts? the blue? and the black?

using this for an expense report and the users indicate cash purchases with
red and credit card with black

Reply to this Message

Paul B - 15 Aug 2005 20:44 GMT

Murph, no built in way, but have a look here on how to do it

http://www.cpearson.com/excel/colors.htm

Signature

Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

> can Excel sum colored fonts?
>
[quoted text clipped - 4 lines]
> with
> red and credit card with black

Reply to this Message