sumif and colored fonts..

M

Murph

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
 
P

Paul B

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

http://www.cpearson.com/excel/colors.htm
--
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to filter rows data based on background color of individual cells 3
SUMIF with criteria "<>" & "=" 4
Conditional Formatting 0
Offset, sum down to the first blank row 7
TransferSpreadsheet to colored fields 0
Excel PrintPreview shows fonts in different colour 0
sumif issues 1
Cell Formatting Conditional On Other Cells Fill Color? 1

Top