Countif function

[jonwhite]

Hi All,

I have searched for this but can't find any thing. Is it possible to do a Countif function against the fill colour of a cell ie =countif(A1,Red fill colour)

Many Thanks in advance

Jon.

**EDIT** sorry, I did not click your second link... that look like just what I need Thank you

 

[Joe4]

Not with a basic Excel function (cannot reference formatting).

You can do it by creating your own Excel function via VBA. I helped a few people do this exact thing. See the following two posts:

http://www.mrexcel.com/board2/viewtopic.php?t=57864&highlight=count+color+colour

http://www.mrexcel.com/board2/viewtopic.php?t=166539&highlight=count+color+colour

 

[jonwhite]

Thankyou for that, The reason I say a countif function is that once I can determine the colour of each cell i wish to use a datafilter to filter off each clour and add a comment in the righthand cell to the filled cell. is there any onther advice you can give

Thanks again
Jon

 

[Joe4]

Basically, what those links do is create a kind of "CountIf" function that work based on color. So it would work like any other Excel function.

So if you imagine that you could do what you want with a CountIf function (if it did color), you should be able to do it with the User Defined Functions in the links provided.