wrote:
From: Dave Bonallack davebonall...@hotmail.com
Subject: $$Excel-Macros$$ Re: Count of Colored Cells
To: excel-macros@googlegroups.com excel-macros@googlegroups.com
Date: Tuesday, September 15, 2009, 1:55 PM
#yiv867146301 .hmmessage P
{
margin:0px;padding:0px;}
#yiv867146301 {
font-size
Hi Pooja
Not possible in 2003 usinf formulas. Have to use VBA.
And if the cells are colored as a result of conditional formatting, it's even
trickier.
Regards - Dave.
Date: Tue, 15 Sep 2009 11:15:43 +0530
Subject: $$Excel-Macros$$ Count of Colored Cells
From: vatspoojav...@gmail.com
To:
Hi Pooja,
Please find attached the file as per your requirement.
Please let me know if you have any questions.
Thanks Regards,
Ankit Mehra
On Tue, Sep 15, 2009 at 11:15 AM, Pooja Sharma vatspoojav...@gmail.comwrote:
Hi Friends,
I have a query regarding counting of Colored cells. I want to
Hi Pooja,
Its possible in MS Excel 2007. There u can filter by colour count the
coloured cells.
Regards,
Lavprasad
On Tue, Sep 15, 2009 at 11:15 AM, Pooja Sharma vatspoojav...@gmail.comwrote:
Hi Friends,
I have a query regarding counting of Colored cells. I want to know, is it
possible
Pooja,
Here is a couple of websites that accomplish this with a user defined
function (UDF).
http://www.exceltip.com/st/Count_by_color_using_VBA_in_Microsoft_Excel/518.html
http://www.ozgrid.com/Excel/count-sum-cell-color.htm
Norman
On Tue, Sep 15, 2009 at 1:45 AM, Pooja Sharma
*See attached file**found very nice function in vba...*
*hope this helps*
Thanks Regards,
Harmeet Singh
Sent via BlackBerry Wireless
On Tue, Sep 15, 2009 at 1:55 PM, Dave Bonallack
davebonall...@hotmail.comwrote:
Hi Pooja
Not possible in 2003 usinf formulas. Have to use VBA.