S
Sam Harman
Hi I have a list of numbers which I would like to automatically format
with a green background......does anyone know how I can do this
3.5
4
5
8
8 the first four values should be highlighted green
10
12
14
14
14
16
0.8 the next four value should be highlighted green
4
6.5
8
14
16
the next four and so on..........the top four values are identified by
the number to start with being smaller than the preceding number
1.2
3
3.5
8
12
2.5 From here top four values to be green
3
3.5
5.5
7.5
10
20
2.75 From here top four values to be green
3.33
5
6.5
2.75 From here top four values to be green
3
4.5
6
8
10
10
33
2.75 From here top four values to be green
3.25
5.5
10
10
12
12
12
14
16
2 From here top four values to be green
7
4.5
6.5
8
10
10
Although I need the top four values to be green, this will sometimes
equte to 6 or 7 numbers as the top four for example
3
4
5
5
5
6
All of these 6 numbers would be highlighted green as they are the top
four values
I hope this makes sense and any help appreciated
thanks
Sam
with a green background......does anyone know how I can do this
3.5
4
5
8
8 the first four values should be highlighted green
10
12
14
14
14
16
0.8 the next four value should be highlighted green
4
6.5
8
14
16
the next four and so on..........the top four values are identified by
the number to start with being smaller than the preceding number
1.2
3
3.5
8
12
2.5 From here top four values to be green
3
3.5
5.5
7.5
10
20
2.75 From here top four values to be green
3.33
5
6.5
2.75 From here top four values to be green
3
4.5
6
8
10
10
33
2.75 From here top four values to be green
3.25
5.5
10
10
12
12
12
14
16
2 From here top four values to be green
7
4.5
6.5
8
10
10
Although I need the top four values to be green, this will sometimes
equte to 6 or 7 numbers as the top four for example
3
4
5
5
5
6
All of these 6 numbers would be highlighted green as they are the top
four values
I hope this makes sense and any help appreciated
thanks
Sam