Calculation based on cell format results

[Guest]

Am looking for a way to count cells that have changed changed due to
conditional formatting.
Eample would be: a cells' format has changed from black text to green due to
data input in the cell. How woul I count the number of cells in the column
that have changed from black to green?

 

[Guest]

Hi,

conditional formatting changes the colors based on a condition ya? so you
can put that condotion in your formula to count.

Thanks,

 

[Gord Dibben]

Not as easy as you think.

You can count using the CF conditions as criteria.

To actually count the green-colored cells is more complex and requires VBA.

See Chip Pearson's site for more info on this.

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


Gord Dibben MS Excel MVP