Counting by conditionally formatted cells

**genus** · 09-23-2009, 04:46 AM

Hello chaps and chapesses,

I'm using this UDF to count cells based on fill color http://www.ozgrid.com/VBA/sum-count-cells-by-color.htm

This seems a well respected method to do so, however, i can only get it to count cells of which i have manually changed the fill color.

Some of my cell colours are changed by Conditional Formatting. I cannot get this UDF to count these cells?

Can anyone help me please?

G

**royUK** · 09-23-2009, 05:07 AM

You need to count the conditions not the colour with Conditional format, attach an example workbook.

**Shijesh Kumar** · 09-23-2009, 05:08 AM

Hi,

Where have you entered this code...
In Sheet1, sheet2 etc module..

Or do you clicked on Insert(Menu) --> Module and there you entered the code..

If you entered in Sheet1 , sheet2 etc module , the function will not work..

**royUK** · 09-23-2009, 05:11 AM

Originally Posted by Shijesh Kumar

Hi,

Where have you entered this code...
In Sheet1, sheet2 etc module..

Or do you clicked on Insert(Menu) --> Module and there you entered the code..

If you entered in Sheet1 , sheet2 etc module , the function will not work..

Hi Shijesh, that code that the OP has used will only count cells whose background colour is set using the Color palette, not Conditional Formatting

**Shijesh Kumar** · 09-23-2009, 05:33 AM

Originally Posted by royUK

Hi Shijesh, that code that the OP has used will only count cells whose background colour is set using the Color palette, not Conditional Formatting

Hi Roy,

Sorry about that .. did see CF??

**royUK** · 09-23-2009, 05:42 AM

No problem, just didn't want yo to waste your time on the wrong track

Counting by conditionally formatted cells

LinkBack

Thread Tools

Rate This Thread

Display

Counting by conditionally formatted cells

re: Counting by conditionally formatted cells

Re: Couting by fill color, ozgrid method won't count conditionally formatted cells

Re: Couting by fill color, ozgrid method won't count conditionally formatted cells

Re: Couting by fill color, ozgrid method won't count conditionally formatted cells

Re: Counting by conditionally formatted cells

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions