Count Conditional Formatting Colours - Excel 2003
 

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

Count Conditional Formatting Colours - Excel 2003
 

it is possible

to achieve that post your code pls


On 4 Mar, 10:46, Chris Stammers <Chris
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

Count Conditional Formatting Colours - Excel 2003
 

Hi,

Look here, it ain't easy!!

http://www.xldynamic.com/source/xld.CFConditions.html
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"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

Count Conditional Formatting Colours - Excel 2003
 

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