Chorususer
New Member
- Joined
- Jul 15, 2008
- Messages
- 28
<TABLE dir=ltr border=1 cellSpacing=0 borderColor=#000000 cellPadding=2 width=1549><TBODY><TR><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD></TR><TR><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD></TR><TR><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
In the above sheet I want to high light per person their lowest scores, once they go over 11 scores entered I want to able to highlight their best 10 only. There will be blank cells along each row as not every week is a score entered.
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
Average
</TD><TD height=16 width="4%">No.Rounds
</TD></TR><TR><TD height=16 width="4%"></TD><TD height=16 width="4%">
1
</TD><TD height=16 width="4%">2
</TD><TD height=16 width="4%">3
</TD><TD height=16 width="4%">4
</TD><TD height=16 width="4%">5
</TD><TD height=16 width="4%">6
</TD><TD height=16 width="4%">7
</TD><TD height=16 width="4%">8
</TD><TD height=16 width="4%">9
</TD><TD height=16 width="4%">10
</TD><TD height=16 width="4%">11
</TD><TD height=16 width="4%">12
</TD><TD height=16 width="4%">13
</TD><TD height=16 width="4%">14
</TD><TD height=16 width="4%">15
</TD><TD height=16 width="4%">16
</TD><TD height=16 width="4%">17
</TD><TD height=16 width="4%">18
</TD><TD height=16 width="4%">19
</TD><TD height=16 width="4%">20
</TD><TD height=16 width="4%"></TD><TD height=16 width="4%">
</TD></TR><TR><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD></TR><TR><TD height=16 width="4%">
Bevan
</TD><TD height=16 width="4%">70
</TD><TD height=16 width="4%">65
</TD><TD height=16 width="4%"></TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
70
</TD><TD height=16 width="4%"></TD><TD height=16 width="4%">
65
</TD><TD height=16 width="4%">70
</TD><TD height=16 width="4%">71
</TD><TD height=16 width="4%">72
</TD><TD height=16 width="4%">73
</TD><TD height=16 width="4%">71
</TD><TD height=16 width="4%">74
</TD><TD height=16 width="4%">80
</TD><TD height=16 width="4%">58
</TD><TD height=16 width="4%">70
</TD><TD height=16 width="4%">85
</TD><TD height=16 width="4%"></TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
68.20
</TD><TD height=16 width="4%">14
</TD></TR><TR><TD height=16 width="4%">Sean
</TD><TD height=16 width="4%">71
</TD><TD height=16 width="4%">68
</TD><TD height=16 width="4%"></TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
70
</TD><TD height=16 width="4%"></TD><TD height=16 width="4%">
62
</TD><TD height=16 width="4%">70
</TD><TD height=16 width="4%">71
</TD><TD height=16 width="4%">72
</TD><TD height=16 width="4%">71
</TD><TD height=16 width="4%">68
</TD><TD height=16 width="4%">75
</TD><TD height=16 width="4%">80
</TD><TD height=16 width="4%">57
</TD><TD height=16 width="4%">70
</TD><TD height=16 width="4%">85
</TD><TD height=16 width="4%"></TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
</TD><TD height=16 width="4%">
67.80
</TD><TD height=16 width="4%">14
</TD></TR></TBODY></TABLE>In the above sheet I want to high light per person their lowest scores, once they go over 11 scores entered I want to able to highlight their best 10 only. There will be blank cells along each row as not every week is a score entered.