Excellent. I hope I didn't give the impression I was unwilling to help more. I am happy to. But if you need more help, I prefer a specific question than just giving a complete solution... so you can gain the most experience and expertise. Asa
-----Original Message----- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ChilExcel Sent: Thursday, May 10, 2012 12:54 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Count & sum color cell, cells have conditional formatting Hi Asa Rossoff I'm working on a solution, with the help of friends, when finished. I send a result Chilexcel 2012/5/8 Asa Rossoff <a...@lovetour.info>: > Hi Chil, > Did you try to use those functions, and if so, please post your effort and > what trouble you are having. > > Asa > > -----Original Message----- > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of ChilExcel > Sent: Tuesday, May 08, 2012 8:08 AM > To: excel-macros@googlegroups.com > Subject: Re: $$Excel-Macros$$ Count & sum color cell, cells have conditional > formatting > > Thx Asa Rossoff ,all this I know, also the links .... > > Please Rajan you help !!! ... > > > Chilexcel > > > 2012/5/7 Asa Rossoff <a...@lovetour.info>: >> Chil, >> Also see Bob Phillip's method @ >> http://www.xldynamic.com/source/xld.CFConditions.html >> >> >> -----Original Message----- >> From: Asa Rossoff [mailto:a...@lovetour.info] >> Sent: Monday, May 07, 2012 4:08 PM >> To: 'excel-macros@googlegroups.com' >> Subject: RE: $$Excel-Macros$$ Count & sum color cell, cells have > conditional >> formatting >> >> Excel has no function to determine conditional formats of cells -- you > have >> to evaluate the same formulas used to color the cells again yourself to >> determine what color/format the cell will have received. >> >> The "simplest" solution is probably to use VBA to evaluate the CFs, see >> http://www.cpearson.com/excel/cfcolors.htm for examples. >> >> Asa >> >> -----Original Message----- >> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] >> On Behalf Of ChilExcel >> Sent: Monday, May 07, 2012 4:01 PM >> To: excel-macros@googlegroups.com >> Subject: $$Excel-Macros$$ Count & sum color cell, cells have conditional >> formatting >> >> hi all >> >> Please I need urgent function for sum and count backColor >> ...cells have conditional formatting >> >> Thx >> >> Chilexcel >> >> >> -- >> Visita ; http://sites.google.com/site/chilexcel/Home >> Visita ; http://www.youtube.com/user/timextag41 >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will >> not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> > ---------------------------------------------------------------------------- >> -------------------------- >> To post to this group, send email to excel-macros@googlegroups.com >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will > not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security > measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. >> >> > ---------------------------------------------------------------------------- > -------------------------- >> To post to this group, send email to excel-macros@googlegroups.com > > > > -- > Visita ; http://sites.google.com/site/chilexcel/Home > Visita ; http://www.youtube.com/user/timextag41 > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will > not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > ---------------------------------------------------------------------------- > -------------------------- > To post to this group, send email to excel-macros@googlegroups.com > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. > > ---------------------------------------------------------------------------- -------------------------- > To post to this group, send email to excel-macros@googlegroups.com -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ---------------------------------------------------------------------------- -------------------------- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
