count conditional format

[shital]

i have given some conditional format to the cell. which
have red, green & black colour. Can it count the cell how
much cell in red colour & green & black.

Thanks in Advance

Shital

 

[Chip Pearson]

Shital,

You need to write VBA functions to do this. See
http://www.cpearson.com/excel/cfcolors.htm for details and example code.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)

 

[Guest]

The same conditions you used for your conditional formatting could be used in the COUNTIF worksheet function, to count the number of occrrences of the conditions that set the cell as red, or green, etc.

Regards

 

[Gord Dibben]

Shital

You should be able to count these cells based upon the same parameters that
produced the colors through Conditional Formatting.

Otherwise see Chip Pearson's website for counting CF cells.

http://www.cpearson.com/excel/CFColors.htm

Here is the preface from this page.

"Unfortunately, the Color and ColorIndex properties of a Range don't return
the color of a cell that is displayed if Conditional formatting is applied to
the cell. Nor does it allow you to determine whether a conditional format is
currently in effect for a cell.
In order to determine these, you need code that will test the format
conditions. This page describes several VBA functions that will do this for
you."

Gord Dibben XL2002