Ranking w/Conditional Formatting

	Notes	Task Name	Score	Rank	Spacer	Table Rank	Table Range	Column7
	Collaboration powered by Smartsheet   |   Report Abuse
1	This table will apply conditional formatting based on the score and where it ranks in relation to the other scores. (red = low to green = high).			0
2		a	0	0		Manual Entry	Formulas in column to right	=INDEX([Table Rank]$2:[Table Rank]$12, MATCH(MIN(COLLECT([Table Range]$2:[Table Range]$12, [Table Range]$2:[Table Range]$12, >=Score@row)), [Table Range]$2:[Table Range]$12, 0))
3		b	1	1		0	0	=MIN(Score:Score)
4		c	2	1		1	2	=(VALUE("." + [Table Rank]@row) * (MAX(Score:Score) - MIN(Score:Score))) + MIN(Score:Score)
5		d	3	2		2	4	Above Formula Dragfilled Down
6		e	4	2		3	6	Above Formula Dragfilled Down
7		f	5	3		4	8	Above Formula Dragfilled Down
8		g	6	3		5	10	Above Formula Dragfilled Down
9		h	7	4		6	12	Above Formula Dragfilled Down
10		i	8	4		7	14	Above Formula Dragfilled Down
11		j	9	5		8	16	Above Formula Dragfilled Down
12		k	10	5		9	18	Above Formula Dragfilled Down
13		l	11	6		10	20	=MAX(Score:Score)
14		m	12	6
15		n	13	7
16		o	14	7
17		p	15	8
18		q	16	8
19		r	17	9
20		s	18	9
21		t	19	10
22		u	20	10