I wouldn't do this.

Instead, I'd use a formula in a different cell that mimics the rules used in the
conditional formatting.

Then I'd use those cells to do the counting--maybe even use them for the
conditional formatting of the original cells. It may make it easier to keep
them in sync.

Chris Stammers wrote:

Hello,

I have a VBA program in Excel 2003 that has been written for me to count
colours. It basically looks for the colour number and counts the number of
occurrences. However, it doesn't work for conditional formatting, as I assume
that the cell isn't actually coloured; it is merely displaying a colour. In
essence, the program is working when cells have actually been coloured. Is
there a way to get the program to recognise the colours in conditional
formatting? All of the variables and colour numbers have been declared in the
program already.

Many thanks.

Regards,
Chris

--

Dave Peterson