Countif Based On Colour Of Cell

[bayoung]

I have been trying to do a countif statement where the variable is the colour of a cell. Positive that this can be done, but am having no luck getting there. Any thoughts?

 

[barry houdini]

If the cells are coloured with Conditional Formatting then you should be able to do a count using the same criteria as CF, otherwise I think you need VBA

 

[Tazguy37]

Have you seen Chip Pearson's code for doing this kind of thing? If you tried it, why doesn't it work for you?

Hope that helps!

 

[Smitty]

Chip Pearson has some methods here.

Hope that helps,

Smitty

 

[bayoung]

Sorted - Thanks.