Sunline
Well-known Member
- Joined
- Oct 6, 2007
- Messages
- 701
- Office Version
- 2016
- Platform
- Windows
Hello all , as per my example sheet im wanting to colour shade these rows standard colour blue and light green .
Col W shows what the result would look like if cells A2:V27 were shaded in these colours and heavy bold lines added .
Col S always contains a number from 3 too 18 , This number is random , there is no order .
If cell S28 said 15 then there would be 15 rows to either colour blue or light green .
In col V 1 or 1= will always be colour blue or light green so hopefully a macro will follow suit to colour and add the border lines .
Thanks .
Col W shows what the result would look like if cells A2:V27 were shaded in these colours and heavy bold lines added .
Col S always contains a number from 3 too 18 , This number is random , there is no order .
If cell S28 said 15 then there would be 15 rows to either colour blue or light green .
In col V 1 or 1= will always be colour blue or light green so hopefully a macro will follow suit to colour and add the border lines .
Thanks .
Excel Workbook | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | O | P | Q | R | S | T | V | W | |||
1 | ID | Class | Dist | Stakes | R# | Fsz | Placing | ||||
2 | 1 | OPN HCP | 1200 | 15,000.00 | 1 | 5 | 5 | 1 | |||
3 | 2 | OPN HCP | 1200 | 15,000.00 | 1 | 5 | 2 | 2 | |||
4 | 3 | OPN HCP | 1200 | 15,000.00 | 1 | 5 | 1 | 3 | |||
5 | 4 | OPN HCP | 1200 | 15,000.00 | 1 | 5 | 3 | 4 | |||
6 | 5 | OPN HCP | 1200 | 15,000.00 | 1 | 5 | 4 | 5 | |||
7 | 6 | MDN HDL | 2760 | 12,500.00 | 2 | 14 | 11 | 1 | |||
8 | 7 | MDN HDL | 2760 | 12,500.00 | 2 | 14 | 1 | 2 | |||
9 | 8 | MDN HDL | 2760 | 12,500.00 | 2 | 14 | 2 | 3 | |||
10 | 9 | MDN HDL | 2760 | 12,500.00 | 2 | 14 | 3 | 4 | |||
11 | 10 | MDN HDL | 2760 | 12,500.00 | 2 | 14 | 14 | 5 | |||
12 | 11 | MDN HDL | 2760 | 12,500.00 | 2 | 14 | 5 | 6 | |||
13 | 12 | MDN HDL | 2760 | 12,500.00 | 2 | 14 | 10 | 7 | |||
14 | 13 | MDN HDL | 2760 | 12,500.00 | 2 | 14 | 7 | 8 | |||
15 | 14 | MDN HDL | 2760 | 12,500.00 | 2 | 14 | 9 | 9 | |||
16 | 15 | MDN HDL | 2760 | 12,500.00 | 2 | 14 | 8 | 10 | |||
17 | 16 | MDN HDL | 2760 | 12,500.00 | 2 | 14 | 13 | 11 | |||
18 | 17 | MDN HDL | 2760 | 12,500.00 | 2 | 14 | 6 | 12 | |||
19 | 18 | MDN HDL | 2760 | 12,500.00 | 2 | 14 | 4 | LR | |||
20 | 19 | MDN HDL | 2760 | 12,500.00 | 2 | 14 | 12 | P | |||
21 | 20 | MDN HWT | 2000 | 7,000.00 | 3 | 7 | 1 | 1 | |||
22 | 21 | MDN HWT | 2000 | 7,000.00 | 3 | 7 | 4 | 2 | |||
23 | 22 | MDN HWT | 2000 | 7,000.00 | 3 | 7 | 7 | 3 | |||
24 | 23 | MDN HWT | 2000 | 7,000.00 | 3 | 7 | 5 | 4 | |||
25 | 24 | MDN HWT | 2000 | 7,000.00 | 3 | 7 | 3 | 5 | |||
26 | 25 | MDN HWT | 2000 | 7,000.00 | 3 | 7 | 6 | 6 | |||
27 | 26 | MDN HWT | 2000 | 7,000.00 | 3 | 7 | 2 | 7 | |||
Sheet1 |