Rank and Conditional Format question

[TheNoocH]

I have 2 questions:
1) I am trying to rank a series of stats for players but want to ignore any players that have not played yet...
2) how can i conditional format these cells ...goal is to highlight green max/min of row based upon if it's a high or low stat...then highlight yellow anything that is better than team average...and then highlight in red anything that is below team average...

hope this example clarifies my intentions...please note that the conditional formatting is actually going to be in top section where stats actually are...i just put in the 2 results sections to show current and desired results...

any help would be great...thanks in advance

Excel Workbook
	A	B	C	D	E	F	G
1	*	Team Average	player 1	player 2	player 3	player 4	player 5
2	stat 1 (high is rank 1)	47.5	50	40	40	0	60
3	stat 2 (high is rank 1)	60	80	40	50	0	70
4	stat 3 (low is rank 1)	20	10	30	20	0	20
5	stat 4 (low is rank 1)	37.5	30	20	50	0	50
6	games played	*	10	10	10	0	10
7	*	*	*	*	*	*	*
8	*	*	*	*	*	*	*
9	Current Results	*	*	*	*	*	*
10	*	*	*	*	*	*	*
11	*	*	player 1	player 2	player 3	player 4	player 5
12	stat 1	*	2	3	4	5	1
13	stat 2	*	1	4	3	5	2
14	stat 3	*	2	5	3	1	4
15	stat 4	*	3	2	4	1	5
16	*	*	*	*	*	*	*
17	*	*	*	*	*	*	*
18	Desired Results	*	*	*	*	*	*
19	*	*	*	*	*	*	*
20	*	*	player 1	player 2	player 3	player 4	player 5
21	stat 1	*	2	3	4	5	1
22	stat 2	*	1	4	3	5	2
23	stat 3	*	1	4	2	5	3
24	stat 4	*	2	1	3	5	4
Sheet1

 

[TheNoocH]

Figured it out...if anyone can think of an easier way I'd be interested in knowing...thanks

Conditional Formatting (just swap the signs for high/low)
Condition 1
=IF(C$6=0,FALSE,0=SUMPRODUCT(--($C2:$G2>C2),--($C$6:$G$6<>0)))
Condition 2
=IF(C$6=0,FALSE,C2>=$B2)
Condition 3
=IF(C$6=0,FALSE,C2<$B2)

Excel Workbook
	A	B	C	D	E	F	G
1		Team Avg	Player 1	Player 2	Player 3	Player 4	Player 5
2	stat 1 (high is rank 1)	47.5	50	40	40	0	60
3	stat 2 (high is rank 1)	60	80	40	50	0	70
4	stat 3 (low is rank 1)	20	10	30	20	0	20
5	stat 4 (low is rank 1)	37.5	30	20	50	0	50
6	games played		10	10	10	0	10
7
8
9	Rank		Player 1	Player 2	Player 3	Player 4	Player 5
10	stat 1 (high is rank 1)		2	3	4	5	1
11	stat 2 (high is rank 1)		1	4	3	5	2
12	stat 3 (low is rank 1)		1	4	2	5	3
13	stat 4 (low is rank 1)		2	1	3	5	4
Sheet1