Bob,

The problem is that I have a whole lot of different
conditions on the different cells - just the colour output
is the thing I need to test.

Bill

-----Original Message-----
Bill,

Test the cells to see if they match the CF criteria. For
instance if the CF
colour if a cell 5 then

=COUNTIF(A1:A1000,"5") will give the count of those
coloured cells.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Bill" wrote in message
...
Hi people,

I have a worksheet with lots of different conditional
formats in different cells.

I want to be able to count all the red(or yellow etc)
cells on my worksheet.

However, this may mean cells that I have formatted
manually, which I know I can count using a test on cells
(x,y).interior.colorindex to increment a variable; or it
could mean cells that have been coloured in red by the
conditional format (using condition 1, 2 or 3, and a
different unrelated formula for each cell).

Hope you can help me,

Bill J. Duke


.