How can I add the values based the color of font and the date

Hello,

I wanted to know if it was possible to add the values of cells based on the
color of font. And while doing this I also need it to do it based on the date
in another cell.

Example: Sheet 1
Qty Date
Cell A1 288 (blue) Cell B1 4/13/2010
Cell A2 190 (red) Cell B2 4/13/2010
Cell A3 400 (blue) Cell B3 4/13/2010
" " 350 (red) " " 4/13/2010
" " 540 (blue) " " 4/12/2010
" " 175 (red) " " 4/12/2010
" " 225 (blue) " " 4/12/2010
" " 180 (red) " " 4/12/2010

My result should look like this if possible: Sheet 2
Column A Column B
4/12/2010 Total 765 (blue)
4/13/2010 Total 688 (blue)

Same Sheet 2 example with the (red) font

Your help is appreciated
Thanks,
Peter

That is going to require VBA unless you can give formula that predicts what
number range gets what colour.
See
http://www.cpearson.com/excel/colors.aspx
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Peter Gonzalez" wrote in message
...
Hello,

I wanted to know if it was possible to add the values of cells based on
the
color of font. And while doing this I also need it to do it based on the
date
in another cell.

Example: Sheet 1
Qty Date
Cell A1 288 (blue) Cell B1 4/13/2010
Cell A2 190 (red) Cell B2 4/13/2010
Cell A3 400 (blue) Cell B3 4/13/2010
" " 350 (red) " " 4/13/2010
" " 540 (blue) " " 4/12/2010
" " 175 (red) " " 4/12/2010
" " 225 (blue) " " 4/12/2010
" " 180 (red) " " 4/12/2010

My result should look like this if possible: Sheet 2
Column A Column B
4/12/2010 Total 765 (blue)
4/13/2010 Total 688 (blue)

Same Sheet 2 example with the (red) font

Your help is appreciated
Thanks,
Peter