EXCEL 2007 HIGHLIGHT MAX&MIN VALUES

Closed
bigband
Posts
11
Registration date
Friday June 11, 2010
Status
Member
Last seen
October 25, 2012
- Dec 21, 2010 at 10:45 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Feb 9, 2011 at 04:38 PM
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


1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Feb 9, 2011 at 04:38 PM
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.


Note:
your data need not be to be real data but a good representative of how data looks like
0