Using CountA to count cells of a certain color

**Richard2012** · 03-12-2012, 02:57 PM

Does CountA have an argument that will return the number of nonblank cells in a range with a specific color?

**daddylonglegs** · 03-12-2012, 03:15 PM

You'd have to use VBA, see Chip Pearson's approach here

**Pete_UK** · 03-12-2012, 03:15 PM

The short answer is No, it doesn't.

Hope this helps.

Pete

**dilipandey** · 03-12-2012, 03:16 PM

Hi Richard,

To count the non-blank cells, CountA will not help and you need to rely upon countblank function But as you are looking to count the specific color, you need to depend on VBA. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>