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
