How to Count or Sum cells with Colors

[Manny74]

Hi All,

I have rows 1 thru 21, with data in column B.

How would I count or sum the number of green cells?

I have tried to google this and want to keep this simple, so I'm hoping I don't need to use VBA....

Sorry, I had colors on my spreadsheet, but when I copied it onto the body of my post, the colors (light green) disappeared, so I made the font Arial black (ex. B2, B4, etc.), so you can pretend those are the light green cells I need to count/sum.....

1	B
2	62.09%
3	699
4	75.40%
5	57
6	0
7	0
8	58
9	88.73%
10	0%
11	1
12	71%
13	33
14	55.49%
15	90.00%
16	0.00
17	0.00
18	1.64
19	511
20	5.01
21	708

<tbody>
</tbody>

 

[Manny74]

Ok so I added some more data, to try to elaborate....
For each user, I have different items they are responsible with different goals that has to be met (Column B & C)
Column D represents their scores-data....
For Discharge %, when he/she exceeds 50%, then it would be green, so 62.09% would be green
For Orders Timeframe when he/she completes the order less than 60 it would be green, so 33 would be green...
So from rows 2 thru 19, only 2 goals were met...So I'd like a count of the green cells to see how goals were met (out of the 10 goals)
It would be 2 goals met (with both 62.09 & 33 being green cells)

	COLUMN B (TARGETS)	COLUMN C (TARGETS AMOUNT -GOAL)	COLUMN D (USER DATA)
ROW 2	Discharge %	50%	62.09%
ROW 3		Total Orders	699
ROW 4	Score	84.47%	75.40%
ROW 5		Surveys	57
ROW 6	Records	3	58
ROW 7	CPOE %	90%	88.73%
ROW 8	Infections %	70%	0%
ROW 9		Cases	1
ROW 10	Attendance	80%	71%
ROW 11	Orders Timeframe	60	33
ROW 12	Rate	75%	55.49%
ROW 16	Length of Stay	1.40	1.64
ROW 17		Cases	511
ROW 18	Length of Stay	5.00	5.01
ROW 19		Cases	708

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

 

[Manny74]

Sorry I accidentally posted my response twice...