Excel: Conditional Formatting woes

SAS

Can't get enough of FH
Joined
Dec 23, 2003
Messages
1,004
This is probably easy to do, but I've not used excel in ages so could do with some help :(

Basically I have a row of data like: 1 x 1 1 1 x o x 1 1
and the cells, with conditional formatting change colour according to the value entered (1-green,o-yellow,x-red).

But I need to tally up the total of each symbols into a table. In this case:

1 - 6
o - 1
x - 3

But any idea what formula I could use to do this? I'm ripping my hair out agghgh :(
 

babs

Can't get enough of FH
Joined
Dec 30, 2003
Messages
1,595
=countif(a1:a10, "1") will give you 6. replace the "1" with "o" or "x" for the other results.
 

Jupitus

Old and short, no wonder I'm grumpy!
Staff member
Moderator
FH Subscriber
Joined
Dec 14, 2003
Messages
3,285
I can't believe I got beaten to an Excel question thread by

WP(ieman)Kenny!!!!

*sobs*


;)
 

Xavier

Can't get enough of FH
Joined
Dec 22, 2003
Messages
1,542
*ahem* jup - it was Babs who posted the tip - WPK just quoted it to give him props :)
 

Jupitus

Old and short, no wonder I'm grumpy!
Staff member
Moderator
FH Subscriber
Joined
Dec 14, 2003
Messages
3,285
Obviously in the wrong forum then, FFS..... ;)
 

Users who are viewing this thread

Top Bottom