View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Farhad Farhad is offline
external usenet poster
 
Posts: 281
Default 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?