Prev: Changing Source Data using V-lookup
Next: Filldown starting from F2 instead of F1
From: Peter Gonzalez on 14 Apr 2010 15:45
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
From: Bernard Liengme on 16 Apr 2010 14:01
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" <PeterGonzalez(a)discussions.microsoft.com> wrote in message
news:2E75E81F-5141-4924-9637-BB23B32B5346(a)microsoft.com...
> 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

 | 
Pages: 1
Prev: Changing Source Data using V-lookup
Next: Filldown starting from F2 instead of F1