Count CF cells

[kdeppe]

Hi,

I'm trying to count cells that are highlighted by conditional formatting. I have the vba code to count cells not highlighted by conditional formatting using the common colorfunction. I'm not sure how to adjust the code to account for CF. Is it difficult?

Thanks,

 

[VoG]

Yes it is difficult: see http://www.cpearson.com/excel/CFColors.htm

It is usually simpler to count the cells that meet the CF condition.

 

[kdeppe]

I figured it'd be more difficult. There is probably an easier way of doing what I'm trying to do. I'm in charge of an office football pool and attached a screenshot. I used CF to highlight if the person got their pick correct or not. What I wanted to achieve was to count the number of cells that are highlighted green, effectively giving me the total number of picks (or "pts") that each person gets. I know the cells aren't numbers, but is there an easier way to count these? Thanks!

-- removed inline image ---