Re revised macro: Max & min values highlighted by font colour.
This macro shown below refers to a previous post on 05-10-2011 Max & min values highlighted by font colour the problem was solved but the data has been moved to new cell locations and i would like to know if Is it possible to modify the revised macro to reflect revised column numbers and additional columns to be highlighted for max and min values
.The original query is as shown below
I have a long list of ratings which are in cols T,U,V,W on a spreadsheet with lots of other data.Is it possible to highlight the max&min values in red & green font respectively in each block that corresponds with the date course & time for that block eg.first block 14/4/11,HAY ,200. col T highest value =58 (red font) lowest value=33 (green font)and so on for cols U,V,W.Some blocks will have 2or 3 ratings with equal high & low ratings in which case they will also be in red & green font.Ihave separated the blocks for ease of illustration,there are normally no empty rows in the data which is around 5000 rows long on excel 2007.Many thanks for any help given.
01/01/1999 NAME course time rate rate rate rate
14/04/2011 name HAY 200 33 77 63 94
14/04/2011 name HAY 200 34 78 63 86
14/04/2011 name HAY 200 36 91 39 82
14/04/2011 name HAY 200 49 86 31 82
14/04/2011 name HAY 200 58 90 50 92
14/04/2011 name HAY 235 74 100 57 94
14/04/2011 name HAY 235 64 100 75 103
14/04/2011 name HAY 235 42 87 56 93
14/04/2011 name HAY 235 64 97 62 95
14/04/2011 name HAY 235 57 94 60 95
14/04/2011 name HAY 235 36 87 6 78
15/04/2011 name BRI 430 77 99 62 94
15/04/2011 name BRI 430 77 97 63 94
15/04/2011 name BRI 430 56 91 59 97
15/04/2011 name BRI 430 64 91 46 92
15/04/2011 name BRI 430 60 94 52 94
15/04/2011 name BRI 430 54 94 0 67
15/04/2011 name BRI 530 35 83 48 91
15/04/2011 name BRI 530 73 99 69 84
15/04/2011 name BRI 530 38 84 61 98
15/04/2011 name BRI 530 70 101 73 101
15/04/2011 name BRI 530 66 103 0 0
16/04/2011 name NEW 345 97 108 83 95
16/04/2011 name NEW 345 30 79 74 105
16/04/2011 name NEW 345 74 99 94 105
16/04/2011 name NEW 345 24 77 96 104
16/04/2011 name NEW 345 58 92 80 96
16/04/2011 name NEW 345 91 107 103 92
16/04/2011 name NEW 345 89 106 84 103
16/04/2011 name NEW 415 80 96 41 79
16/04/2011 name NEW 415 53 85 71 87
16/04/2011 name NEW 415 37 78 32 72
16/04/2011 name NEW 415 81 96 31 80
16/04/2011 name NEW 415 60 88 57 91
16/04/2011 name NEW 415 44 81 58 53
16/04/2011 name NEW 415 86 98 71 91
18/04/2011 name WIN 650 51 86 72 93
18/04/2011 name WIN 650 39 81 71 100
18/04/2011 name WIN 650 71 95 78 99
18/04/2011 name WIN 650 72 96 48 91
18/04/2011 name WIN 650 31 80 55 97
18/04/2011 name WIN 720 69 96 62 90
18/04/2011 name WIN 720 81 100 68 88
18/04/2011 name WIN 720 75 98 75 84
18/04/2011 name WIN 720 68 95 72 96
18/04/2011 name WIN 720 87 103 87 93
18/04/2011 name WIN 720 66 94 31 72
The macro to solve it as written by Leith Ross is
The changes from the original spreadsheet (where the range was p2:w2) are an additional heading added and these headings are now moved to cols A-E,cols f to g and ag to ai contain no data for highlighting.Cols T to AF and AJ to AN contain ratings to be highlighted as per the original query.Revised headings are as shown below
A B C D E f-g T -AF ag-ai AJ AK AL AM AN
date sad name course time
Many thanks for any help.
Bookmarks