Count cell by Colour not number

[madforgolf]

I have searched her and web and cant find what I can use.

Im looking to count the cells in a range that are coloured RED
I have tried a few ways even =countcolor(c2:aa2,3,false) but nothing

Any ideas without vba code

Marty

 

[Joe4]

I have tried a few ways even =countcolor(c2:aa2,3,false) but nothing

Where did you get "countcolor" from? All the references I have found on-line for it show how it is a VBA User Defined Function (see: Count The Number of Cells With Specific Cell Color By Using VBA)

Check out this link here: How to count and sum cells based on background color in Excel?
and note what it says:

In Excel, there is no direct formula to calculate Sum and Count of color cells, here I will introduce you some ways to solve this problem.

Note, if your cells are colored due to Conditional Formatting, you may be able to get what you want indirectly by using the same condition to count the cells (instead of trying to count the color). Or if the cells are colored due to some specific reason that can be identified with a formula, you could use that also.

Otherwise, I think you are stuck using VBA.

 

[madforgolf]

Thanks for the reply, Vba looks like the only way I can do this.

Cheers Marty