• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Countif on Colour filter

Dear Solvers,


I have data from A column to E column ,In Which E column(Status) has conditional formatting to Red Green Yellow

Need no.of red, green , yellow items
 
Senthilkumar_rm


Counting colors of Conditionally Formatted cells is hard

But replicating the same logic as the CF in a Countif or Sumproduct is generally a lot easier


can you tell us what logic is used in the CF? or post a sample file?
 
Hi Senthikumar_rm


Hui makes a good point. Difficult to count CF colour. Easy to do with Countif though, Putting this idea into a spreadsheet can be seen at the link below.


http://rapidshare.com/files/1651575822/CF.xlsm


Take care


Smallman
 
Back
Top