Formula for counting colors?

[sssb2000]

hi,
i have a table with cells that are one of 3 different colors (green/yellow/red).
is there anyway that i can count lets say the total number of RED cells in A1:A10?

 

[Scott Huish]

Why are they red? Did you manually color the cells or is it a result of Conditional Formatting?

 

[sssb2000]

Why are they red? Did you manually color the cells or is it a result of Conditional Formatting?

they are manually turned Red.
I wish i could use conditional formatting but the program i'm trying to use (Xcelsius) doesn't allow for conditional formatting......so, i'm forced to do the coloring manually, and now, i need to somehow count them.

 

[Scott Huish]

I'm sorry I don't know what Xcelsius is, but is there a condition you could write a formula to count by?

 

[sssb2000]

I'm sorry I don't know what Xcelsius is, but is there a condition you could write a formula to count by?

i guess that's what my question is.....if it's possible to count the cells that have certain colors.
if you're asking if there's 'another place' where there's a different 'condition' like 1, 2 or 3, then No, there isn't. i have the colors to work with.

 

[alansidman]

Take a look at this video. It should help you figure out your issue.

http://www.datapigtechnologies.com/flashfiles/SortonColor.html

Alan

 

[Scott Huish]

No, what I am asking is what is the reasoning behind the different colors? Is it based on something?

 

[sssb2000]

No, what I am asking is what is the reasoning behind the different colors? Is it based on something?

oh i see.
no, not really. they are essentially weaknesses. so red indicates that the area needs improvements.

 

[sssb2000]

Take a look at this video. It should help you figure out your issue.

http://www.datapigtechnologies.com/flashfiles/SortonColor.html

Alan

Alan,
thanks for the link. i watched the video and that's very interesting....however, i can't use VBA or macros. it has to be a formula.
(xcelsius doesn't support conditional formatting or macros!)

 

[sssb2000]

based on all the searching i've been doing, it seems like counting colored cells with a formula is impossible in EXCEL!