Condtional Formatting

[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

I hope this makes sense and any help appreciated

thanks

Sam

 

[Sam Harman]

oops that should read A5:A100

because..

Hi Colin and thanks for taking the time to do this for me......it is
almost perfect but not quite

I have attached a spreadsheet to show where the error is...perhaps it
is me inputting the formula but any help for an idiot would be
appreciated lol

Thanks

Sam

 

[Sam Harman]

Ok thanks Colin, any help appreciated

Cheers

Sam