Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculate based on color
Every time ya'll have helped I was working on something for the corporate office, now I've been transferred to the corporate office - not sure if that's good or bad... Routing and scheduling workbook with multiple tabs. We have three colors of rows to signify the status (open, closed, issue) I want to calculate the number of blue rows (issue) to the front (summary) tab. Is that possible, like a COUNTIF formula?? I could just add another regular formula and have numerical codes for the same thing, but there is aready enough business going on in there. If not possible, any ideas? The open/losed calculation is no big deal, but there are about 30 different subsets under "issue" and don't really want to do another giant validation... -- redneck joe ------------------------------------------------------------------------ redneck joe's Profile: http://www.excelforum.com/member.php...o&userid=32570 View this thread: http://www.excelforum.com/showthread...hreadid=561203 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculate based on color
Hi redneck joe
See http://www.xldynamic.com/source/xld.ColourCounter.html -- Regards Ron de Bruin http://www.rondebruin.nl "redneck joe" wrote in message ... Every time ya'll have helped I was working on something for the corporate office, now I've been transferred to the corporate office - not sure if that's good or bad... Routing and scheduling workbook with multiple tabs. We have three colors of rows to signify the status (open, closed, issue) I want to calculate the number of blue rows (issue) to the front (summary) tab. Is that possible, like a COUNTIF formula?? I could just add another regular formula and have numerical codes for the same thing, but there is aready enough business going on in there. If not possible, any ideas? The open/losed calculation is no big deal, but there are about 30 different subsets under "issue" and don't really want to do another giant validation... -- redneck joe ------------------------------------------------------------------------ redneck joe's Profile: http://www.excelforum.com/member.php...o&userid=32570 View this thread: http://www.excelforum.com/showthread...hreadid=561203 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculate based on color
in a similar vein is there a list somewhere of which numbers map to which colours as far as excel is concerned. i.e. if 3 = red background what is 1,2,4,etc...without me having to put them all in obviously. thanks in advance -- MDubbelboer ------------------------------------------------------------------------ MDubbelboer's Profile: http://www.excelforum.com/member.php...o&userid=36330 View this thread: http://www.excelforum.com/showthread...hreadid=561203 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculate based on color
See
http://www.mvps.org/dmcritchie/excel/colors.htm -- Regards Ron de Bruin http://www.rondebruin.nl "MDubbelboer" wrote in message ... in a similar vein is there a list somewhere of which numbers map to which colours as far as excel is concerned. i.e. if 3 = red background what is 1,2,4,etc...without me having to put them all in obviously. thanks in advance -- MDubbelboer ------------------------------------------------------------------------ MDubbelboer's Profile: http://www.excelforum.com/member.php...o&userid=36330 View this thread: http://www.excelforum.com/showthread...hreadid=561203 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculate based on color
Cool - one more question: Another COUNTIF ~ i have a column that contains date and time frame (07/06/2006 AM) and I want to COUNTIF the AM or PM part of that cell. Possible or only if I break that out? Ron de Bruin Wrote: Hi redneck joe See http://www.xldynamic.com/source/xld.ColourCounter.html -- Regards Ron de Bruin http://www.rondebruin.nl -- redneck joe ------------------------------------------------------------------------ redneck joe's Profile: http://www.excelforum.com/member.php...o&userid=32570 View this thread: http://www.excelforum.com/showthread...hreadid=561203 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculate based on color
wonderful. thanks Ron de Bruin Wrote: See http://www.mvps.org/dmcritchie/excel/colors.htm -- Regards Ron de Bruin http://www.rondebruin.nl -- MDubbelboer ------------------------------------------------------------------------ MDubbelboer's Profile: http://www.excelforum.com/member.php...o&userid=36330 View this thread: http://www.excelforum.com/showthread...hreadid=561203 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculate based on color
=sumproduct(--(right(a1:a10,2)="AM"))
Adjust the ranges to match--but you can't use whole columns. =sumproduct() likes to work with numbers. The -- stuff changes trues and falses to 1's and 0's. Bob Phillips explains =sumproduct() in much more detail he http://www.xldynamic.com/source/xld.SUMPRODUCT.html And J.E. McGimpsey has some notes at: http://mcgimpsey.com/excel/formulae/doubleneg.html redneck joe wrote: Cool - one more question: Another COUNTIF ~ i have a column that contains date and time frame (07/06/2006 AM) and I want to COUNTIF the AM or PM part of that cell. Possible or only if I break that out? Ron de Bruin Wrote: Hi redneck joe See http://www.xldynamic.com/source/xld.ColourCounter.html -- Regards Ron de Bruin http://www.rondebruin.nl -- redneck joe ------------------------------------------------------------------------ redneck joe's Profile: http://www.excelforum.com/member.php...o&userid=32570 View this thread: http://www.excelforum.com/showthread...hreadid=561203 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change color pattern based upon a formula within a cell? | Excel Worksheet Functions | |||
How can I calculate amount of time left based on amount spent? | Excel Worksheet Functions | |||
Calculate gross profit based on varying percentages | Excel Worksheet Functions | |||
change cell color based on cell value | Excel Worksheet Functions | |||
calculate numbers based on font color? | Excel Worksheet Functions |