The simplest way is to count using the condition that you have in CF.

For instance,

="Num reds = " & COUNTIF(A1:A100,100)

Counting CF colours is convoluted.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"DMc2004" wrote in message
...
I currently have a spreadsheet that has conditional formatting applied to
its
rows. This conidtional formatting works by looking at the values in cells.

I would like to be able to count the colours within the conditional
formatting, ie

Red = 100
Orange = 50
Green = 360

I cannot use countif becuase the conidtional formatting
(Format-Conditional
Formatting) uses a complex formulas, how can i do this using VBA.

Thanks