Calculation based on cell format results
 

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?

Calculation based on cell format results
 

Hi,

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

Thanks,
--
Farhad Hodjat


"Japs" wrote:

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?

Calculation based on cell format results
 

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

On Fri, 18 May 2007 08:58:00 -0700, Japs wrote:

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?