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" <(E-Mail Removed)> wrote in message
news:2E75E81F-5141-4924-9637-(E-Mail Removed)...
> 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