EXCEL 2007 HIGHLIGHT MAX&MIN VALUES

Hello, I have lists around 500 rows long each group of dates ×& marks separated by an empty row is there a macro to highlight the max&min values in the marks cols for each group of dates and times red &green font respectively some values are duplicated eg
eg first group col c 76red,54greenfont,col F 97*3green,101 red.Many thanks for help.
14/12/2010 01:05 54 89 66 97 86 109
14/12/2010 01:05 76 106 57 101 84 100
14/12/2010 01:05 67 91 66 97 61 96
14/12/2010 01:05 73 97 70 97 83 98

14/12/2010 01:40 71 104 70 97 76 101
14/12/2010 01:40 79 101 81 108 70 100
14/12/2010 01:40 87 109 80 112 75 102

15/12/2010 02:15 61 88 58 93 84 103
15/12/2010 02:15 71 73 76 90 106 112
15/12/2010 02:15 59 96 57 90 87 101
15/12/2010 02:15 71 97 77 93 73 97
15/12/2010 02:15 32 87 73 100 72 102
15/12/2010 02:15 24 73 61 88 59 87