Hi
I am looking to see if this is posible.
I have a spreadsheet attached. The numbers correlate to making an image by clicking "Create black cells".
If you them goto the "Implementation" tab you will ten see the image.
If i alter the image by filling in more cells on that tab to black then click "exract values" it alters the original numbers to correspond to the image
I am looking to make it so that if i change the black cells on the implemenation tab the corresponding number on the cat 5 tab will fill with the same colour.
can this be done ?
I am looking to see if this is posible.
I have a spreadsheet attached. The numbers correlate to making an image by clicking "Create black cells".
If you them goto the "Implementation" tab you will ten see the image.
If i alter the image by filling in more cells on that tab to black then click "exract values" it alters the original numbers to correspond to the image
I am looking to make it so that if i change the black cells on the implemenation tab the corresponding number on the cat 5 tab will fill with the same colour.
can this be done ?
zbor to test.xlsm | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | |||
1 | Maximum rows | 300 | ||||||||||||||||||||||||||||
2 | Maximum columns | 300 | ||||||||||||||||||||||||||||
3 | ||||||||||||||||||||||||||||||
4 | 1 | 3 | 7.1 | |||||||||||||||||||||||||||
5 | 2 | 2.8 | 7.3 | |||||||||||||||||||||||||||
6 | 3 | 2.8 | 7.3 | 10.4 | 11.4 | |||||||||||||||||||||||||
7 | 4 | 2.7 | 7.4 | 10.2 | 11.7 | |||||||||||||||||||||||||
8 | 5 | 2.7 | 2.9 | 7.2 | 7.4 | 10 | 11.8 | |||||||||||||||||||||||
9 | 6 | 2.7 | 2.9 | 7.2 | 7.4 | 9.9 | 12 | 13.4 | 13.5 | 14.6 | 14.7 | 17.2 | 17.4 | |||||||||||||||||
10 | 7 | 2.7 | 2.8 | 3.1 | 7 | 7.3 | 7.5 | 9.8 | 12.1 | 13.3 | 13.6 | 14 | 14.1 | 14.6 | 14.8 | 17 | 17.4 | |||||||||||||
11 | 8 | 2.7 | 2.8 | 3 | 7.1 | 7.3 | 7.5 | 9.7 | 12.2 | 13.3 | 13.6 | 13.9 | 14.2 | 14.6 | 14.8 | 16.7 | 17.4 | |||||||||||||
12 | 9 | 2.7 | 2.8 | 3 | 7.1 | 7.3 | 7.5 | 9.6 | 12.3 | 13.3 | 13.6 | 13.8 | 14.3 | 14.6 | 14.8 | 16.5 | 17.4 | |||||||||||||
13 | 10 | 2.7 | 2.8 | 3 | 7.1 | 7.3 | 7.5 | 9.6 | 12.3 | 13.3 | 13.6 | 13.8 | 14.3 | 14.6 | 14.8 | 16.3 | 17.2 | |||||||||||||
14 | 11 | 2.7 | 2.8 | 3 | 4.8 | 5 | 7.1 | 7.3 | 7.5 | 9.5 | 12.4 | 13.3 | 13.6 | 13.8 | 14.3 | 14.6 | 14.8 | 16.1 | 17 | |||||||||||
15 | 12 | 2.7 | 2.8 | 3 | 4.6 | 5.2 | 7.1 | 7.3 | 7.5 | 9.4 | 12.4 | 13.3 | 13.6 | 13.8 | 14.3 | 14.6 | 14.8 | 15.8 | 16.8 | 17 | 17.1 | |||||||||
16 | 13 | 2.6 | 2.8 | 3 | 4.5 | 5.3 | 7.1 | 7.4 | 7.5 | 9.4 | 12.5 | 13.3 | 13.6 | 13.9 | 14.3 | 14.6 | 14.8 | 15.6 | 16.6 | 17 | 17.3 | |||||||||
17 | 14 | 2.6 | 2.8 | 3 | 4.5 | 5.3 | 7.2 | 7.4 | 7.5 | 9.3 | 10.7 | 11.1 | 12.5 | 13.3 | 13.6 | 13.9 | 14.2 | 14.6 | 14.8 | 15.4 | 16.5 | 16.8 | 17.4 | |||||||
18 | 15 | 2.6 | 2.8 | 3 | 4.4 | 5.4 | 7.2 | 7.4 | 7.5 | 9.3 | 10.4 | 11.4 | 12.6 | 13.3 | 13.6 | 14.6 | 14.8 | 15.2 | 16.5 | 16.7 | 17.4 | |||||||||
19 | 16 | 2.6 | 2.7 | 3 | 4.4 | 5.4 | 7.2 | 7.4 | 7.6 | 9.3 | 10.2 | 11.6 | 12.6 | 13.3 | 13.6 | 14.6 | 14.8 | 15.2 | 15.9 | 16.1 | 16.4 | 16.7 | 17.4 | |||||||
20 | 17 | 2.5 | 2.7 | 2.9 | 4.4 | 5.4 | 7.2 | 7.4 | 7.6 | 9.2 | 10.1 | 11.7 | 12.7 | 13.3 | 13.6 | 14.6 | 14.8 | 15.2 | 15.7 | 16.1 | 16.3 | 16.6 | 16.9 | 17.2 | 17.4 | |||||
21 | 18 | 2.5 | 2.7 | 2.9 | 4.4 | 5.4 | 7.2 | 7.5 | 7.6 | 9.2 | 10 | 11.8 | 12.7 | 13.3 | 13.6 | 14.6 | 14.8 | 15.2 | 15.4 | 16 | 16.3 | 16.6 | 16.9 | 17.2 | 17.4 | |||||
22 | 19 | 2.5 | 2.7 | 2.9 | 4.4 | 5.4 | 7.3 | 7.5 | 7.6 | 9.2 | 9.9 | 11.9 | 12.7 | 13.3 | 13.6 | 14 | 14.1 | 14.6 | 14.8 | 16 | 16.3 | 16.6 | 16.9 | 17.2 | 17.4 | |||||
23 | 20 | 2.5 | 2.7 | 2.9 | 4.4 | 5.4 | 7.3 | 7.5 | 7.7 | 9.2 | 9.9 | 12 | 12.8 | 13.3 | 13.6 | 13.9 | 14.2 | 14.6 | 14.8 | 16 | 16.3 | 16.5 | 16.8 | 17.2 | 17.4 | |||||
24 | 21 | 2.4 | 2.6 | 2.9 | 4.4 | 5.4 | 7.3 | 7.5 | 7.7 | 9.1 | 9.8 | 12.1 | 12.8 | 13.3 | 13.6 | 13.8 | 14.3 | 14.6 | 14.8 | 16 | 16.8 | 17.2 | 17.4 | |||||||
25 | 22 | 2.4 | 2.6 | 2.8 | 4.4 | 5.4 | 7.3 | 7.6 | 7.7 | 9.1 | 9.8 | 12.1 | 12.8 | 13.3 | 13.6 | 13.8 | 14.3 | 14.6 | 14.8 | 16.1 | 16.7 | 17.1 | 17.4 | |||||||
26 | 23 | 2.4 | 2.6 | 2.8 | 4.4 | 5.4 | 7.4 | 7.6 | 7.7 | 9.1 | 9.7 | 12.1 | 12.8 | 13.3 | 13.6 | 13.8 | 14.3 | 14.6 | 14.8 | 16.1 | 16.6 | 17.1 | 17.4 | |||||||
27 | 24 | 2.3 | 2.5 | 2.8 | 4.5 | 5.4 | 7.4 | 7.6 | 7.8 | 9.1 | 9.7 | 12.2 | 12.8 | 13.3 | 13.6 | 13.8 | 14.3 | 14.6 | 14.8 | 16.2 | 16.5 | 17 | 17.3 | |||||||
28 | 25 | 2.3 | 2.5 | 2.7 | 4.5 | 5.3 | 7.4 | 7.6 | 7.8 | 9.1 | 9.7 | 12.2 | 12.8 | 13.3 | 13.6 | 13.9 | 14.3 | 14.6 | 14.8 | 16.9 | 17.2 | |||||||||
29 | 26 | 2.2 | 2.5 | 2.7 | 4.6 | 5.2 | 7.4 | 7.7 | 7.8 | 9.1 | 9.7 | 12.2 | 12.8 | 13.3 | 13.6 | 13.9 | 14.2 | 14.6 | 14.8 | 16.8 | 17.2 | |||||||||
30 | 27 | 2.2 | 2.4 | 2.7 | 4.7 | 5.1 | 7.5 | 7.7 | 7.9 | 9.1 | 9.7 | 12.2 | 12.8 | 13.3 | 13.6 | 14.6 | 14.8 | 16.6 | 17.4 | |||||||||||
31 | 28 | 2.2 | 2.4 | 2.6 | 7.5 | 7.7 | 7.9 | 9.1 | 9.7 | 12.2 | 12.8 | 13.3 | 13.6 | 14.6 | 14.8 | 16.4 | 17.4 | |||||||||||||
32 | 29 | 2.1 | 2.3 | 2.6 | 6 | 6.6 | 7.5 | 7.8 | 8 | 9.1 | 9.7 | 12.2 | 12.8 | 13.3 | 13.6 | 14.6 | 14.8 | 16.2 | 17.4 | |||||||||||
33 | 30 | 2.1 | 2.3 | 2.5 | 5.8 | 6.8 | 7.6 | 7.8 | 8 | 9.1 | 9.7 | 12.2 | 12.8 | 13.3 | 13.6 | 14.6 | 14.8 | 16.1 | 16.9 | 17.2 | 17.4 | |||||||||
34 | 31 | 2 | 2.2 | 2.5 | 5.7 | 7 | 7.6 | 7.9 | 8.1 | 9.1 | 9.7 | 12.2 | 12.8 | 13.3 | 13.6 | 14 | 14.1 | 14.6 | 14.8 | 16.1 | 16.7 | 17.2 | 17.4 | |||||||
35 | 32 | 1.9 | 2.2 | 2.4 | 5.6 | 7.1 | 7.7 | 7.9 | 8.4 | 9.1 | 9.7 | 12.2 | 12.8 | 13.3 | 13.6 | 13.9 | 14.2 | 14.6 | 14.8 | 15.6 | 15.9 | 16.1 | 16.5 | 17.2 | 17.4 | |||||
36 | 33 | 1.7 | 2.1 | 2.4 | 5.5 | 7.2 | 7.7 | 8 | 8.5 | 9.1 | 9.7 | 12.2 | 12.8 | 13.3 | 13.6 | 13.8 | 14.3 | 14.6 | 14.8 | 15.6 | 15.9 | 16.1 | 16.3 | 17.1 | 17.4 | |||||
37 | 34 | 1.6 | 2.1 | 2.3 | 5.4 | 7.2 | 7.8 | 8.1 | 8.6 | 9.1 | 9.7 | 12.2 | 12.8 | 13.3 | 13.6 | 13.8 | 14.3 | 14.6 | 14.8 | 15.6 | 15.9 | 17 | 17.3 | |||||||
38 | 35 | 1.6 | 2 | 2.2 | 5.3 | 7.3 | 7.9 | 8.3 | 8.6 | 9.1 | 9.7 | 12.1 | 12.8 | 13.3 | 13.6 | 13.8 | 14.3 | 14.6 | 14.8 | 15.6 | 15.9 | 16.9 | 17.3 | |||||||
39 | 36 | 1.5 | 1.8 | 2.2 | 5.3 | 7.4 | 7.9 | 8.4 | 8.7 | 9.1 | 9.8 | 12.1 | 12.8 | 13.3 | 13.6 | 13.8 | 14.3 | 14.6 | 14.8 | 16.8 | 17.2 | |||||||||
40 | 37 | 1.5 | 1.7 | 2.1 | 5.2 | 6 | 6.7 | 7.4 | 8.1 | 8.5 | 8.7 | 9.1 | 9.8 | 12.1 | 12.8 | 13.3 | 13.6 | 13.9 | 14.3 | 14.6 | 14.8 | 16.7 | 17.2 | |||||||
41 | 38 | 1.5 | 1.7 | 1.9 | 5.2 | 5.8 | 6.8 | 7.5 | 8.3 | 8.5 | 8.7 | 9.2 | 9.9 | 12 | 12.8 | 13.3 | 13.6 | 13.9 | 14.2 | 14.6 | 14.8 | 16.5 | 17.3 | |||||||
42 | 39 | 1.5 | 1.7 | 1.9 | 5.1 | 5.7 | 6.9 | 7.5 | 8.3 | 8.5 | 8.7 | 9.2 | 9.9 | 11.9 | 12.7 | 13.3 | 13.6 | 14.6 | 14.8 | 16.4 | 17.4 | |||||||||
43 | 40 | 1.5 | 1.7 | 1.9 | 5.1 | 5.7 | 7 | 7.5 | 8.3 | 8.5 | 8.7 | 9.2 | 10 | 11.9 | 12.7 | 13.3 | 13.6 | 14.6 | 14.8 | 16.3 | 17.4 | |||||||||
44 | 41 | 1.5 | 1.7 | 1.9 | 5.1 | 5.6 | 7 | 7.6 | 8.3 | 8.5 | 8.7 | 9.2 | 10.1 | 11.8 | 12.7 | 13.3 | 13.6 | 14.6 | 14.8 | 16.2 | 16.8 | 17.2 | 17.4 | |||||||
45 | 42 | 1.5 | 1.7 | 1.9 | 3.1 | 3.5 | 5 | 5.6 | 7.1 | 7.6 | 8.3 | 8.5 | 8.7 | 9.3 | 10.2 | 11.6 | 12.6 | 13.3 | 13.6 | 14.6 | 14.8 | 16.2 | 16.6 | 17.2 | 17.4 | |||||
46 | 43 | 1.5 | 1.7 | 1.9 | 3 | 3.5 | 5 | 5.5 | 7.1 | 7.6 | 8.3 | 8.5 | 8.7 | 9.3 | 10.4 | 11.5 | 12.6 | 13.3 | 13.6 | 14 | 14.1 | 14.6 | 14.8 | 16.1 | 16.5 | 17.2 | 17.4 | |||
47 | 44 | 1.5 | 1.7 | 1.9 | 2.9 | 3.5 | 5 | 5.5 | 7.2 | 7.7 | 8.3 | 8.5 | 8.7 | 9.3 | 10.7 | 11.2 | 12.6 | 13.3 | 13.6 | 13.9 | 14.2 | 14.6 | 14.8 | 16.1 | 16.4 | 17.2 | 17.4 | |||
48 | 45 | 1.5 | 1.7 | 1.9 | 2.9 | 3.5 | 5 | 5.4 | 7.2 | 7.7 | 8.3 | 8.5 | 8.7 | 9.4 | 12.5 | 13.3 | 13.6 | 13.8 | 14.3 | 14.6 | 14.8 | 16.1 | 16.3 | 17.1 | 17.4 | |||||
49 | 46 | 1.5 | 1.7 | 1.9 | 2.8 | 3.5 | 5 | 5.4 | 7.2 | 7.7 | 8.3 | 8.5 | 8.7 | 9.4 | 12.5 | 13.3 | 13.6 | 13.8 | 14.3 | 14.6 | 14.8 | 16.1 | 16.3 | 17 | 17.4 | |||||
50 | 47 | 1.5 | 1.7 | 1.9 | 2.7 | 3.4 | 5 | 5.4 | 6 | 6.5 | 7.3 | 7.7 | 8.3 | 8.5 | 8.7 | 9.5 | 12.4 | 13.3 | 13.6 | 13.8 | 14.3 | 14.6 | 14.8 | 16.1 | 16.3 | 16.9 | 17.3 | |||
51 | 48 | 1.5 | 1.7 | 1.9 | 2.7 | 3.3 | 4.9 | 5.4 | 5.8 | 6.5 | 7.3 | 7.7 | 8.3 | 8.5 | 8.7 | 9.6 | 12.3 | 13.3 | 13.6 | 13.8 | 14.3 | 14.6 | 14.8 | 16.1 | 16.3 | 16.7 | 17.3 | |||
52 | 49 | 1.5 | 1.7 | 1.9 | 2.6 | 3.2 | 4.9 | 5.4 | 5.6 | 6.5 | 7.3 | 7.8 | 8.3 | 8.5 | 8.7 | 9.6 | 12.2 | 13.3 | 13.6 | 13.9 | 14.3 | 14.6 | 14.8 | 16.1 | 17.4 | |||||
53 | 50 | 1.5 | 1.7 | 1.9 | 2.6 | 3.1 | 4.9 | 5.4 | 5.5 | 6.5 | 7.3 | 7.8 | 8.3 | 8.5 | 8.7 | 9.7 | 12.2 | 13.3 | 13.6 | 13.9 | 14.2 | 14.6 | 14.8 | 16.1 | 17.4 | |||||
54 | 51 | 1.5 | 1.7 | 1.9 | 2.5 | 3.1 | 4.9 | 6.5 | 7.3 | 7.8 | 8.3 | 8.5 | 8.7 | 9.8 | 12.1 | 13.3 | 13.6 | 14.6 | 14.8 | 16.1 | 17.4 | |||||||||
55 | 52 | 1.5 | 1.7 | 1.9 | 2.5 | 3 | 4.9 | 6.4 | 7.3 | 7.8 | 8.3 | 8.5 | 8.7 | 9.9 | 12 | 13.3 | 13.6 | 14.6 | 14.8 | 15.9 | 16.9 | 17.2 | 17.4 | |||||||
56 | 53 | 1.5 | 1.7 | 1.9 | 2.5 | 3 | 4.7 | 6.3 | 7.4 | 7.8 | 8.3 | 8.5 | 8.7 | 10 | 11.8 | 13.3 | 13.6 | 14.6 | 14.8 | 15.6 | 16.6 | 17.2 | 17.4 | |||||||
57 | 54 | 1.5 | 1.7 | 1.9 | 2.4 | 2.9 | 4.5 | 6.1 | 7.4 | 7.8 | 8.3 | 8.5 | 8.7 | 10.2 | 11.7 | 13.3 | 13.6 | 14.6 | 14.8 | 15.4 | 16.4 | 17.1 | 17.4 | |||||||
58 | 55 | 1.5 | 1.7 | 1.9 | 2.4 | 2.9 | 4.3 | 5.4 | 5.5 | 5.9 | 7.4 | 7.8 | 8.3 | 8.5 | 8.7 | 10.4 | 11.5 | 13.3 | 13.6 | 14 | 14.1 | 14.6 | 14.8 | 15.2 | 16.2 | 17.1 | 17.4 | |||
59 | 56 | 1.5 | 1.7 | 1.9 | 2.4 | 2.8 | 4.1 | 5.4 | 7.4 | 7.8 | 8.3 | 8.5 | 8.7 | 10.8 | 11.1 | 13.3 | 13.6 | 13.9 | 14.2 | 14.6 | 14.8 | 15.2 | 16 | 17 | 17.3 | |||||
60 | 57 | 1.5 | 1.7 | 1.9 | 2.4 | 2.8 | 3.8 | 5.4 | 7.4 | 7.8 | 8.3 | 8.5 | 8.7 | 13.3 | 13.6 | 13.8 | 14.3 | 14.6 | 14.8 | 15.2 | 15.7 | 16.9 | 17.2 | |||||||
cat5 |