If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
How can I add the values based the color of font and the date
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 |
Thread Tools | |
Display Modes | |
|
|