count coloured cells

[Guest]

Hi
How can I count cells which are formatted in colour? I have tried the
countif function, but it does not work. I cannot use the conditional
formatting, because the cell values contain only text, which is not
repeating. So I have to manually colour the cells.

Please advise.

ile

 

[Guest]

See:

http://www.cpearson.com/excel/colors.htm

 

[Guest]

Thanks for the help. Unfortunately I'm not that familiar with VB coding. I
copied the code to VB editor, but it didn't work. What am I doing wrong?

Any solutions?

ile

 

[Chip Pearson]

In the VBA Editor, go to the Insert menu and choose Module. Paste
the code in that module.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Guest]

Thanks Chip. I managed to get the 'colorindex' function to work, but the
'countbycolor' gives an error message. I guess the problem is with the
syntax. I've tried many variations to it, but still can't get it to work.

This means a trip to library and reading VBA basics...

Many thanks for the help.

ile