Not easy, but Chip has a function at his site
http://www.cpearson.com/excel/CFColors.htm

IMO, it is better to count the conditions that force the colour. SO for
instance, if the cells are green if the value is 10 then use

=COUNTIF(A1:A100,"10")

--

HTH

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


"MDR5300" wrote in message
...
I need a little help in how to determine the color index of a cell that is
formatted with ondition formatting.

The spreadsheet formats the color of the cells to RED, Yellow, Or Green
with
conditional formatting and I need to be able to count the number of Cells
in
a range that are green. The cells interior color index properity does not
give me the color value when conditional formatting is used.

Im using EXCEL 2002 SP3