Spreadsheet: 84204d1284200278-conditional-formatting-problem-a-true-north-finder1
Sheet: true north finder

True north/south line table |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | if gmt = 9:30, the standard meridian should be 142.5 not 143
 |  |  |  |  |  |  |  | input yellow cells |  |  |  |  |  |  |  | if gmt = 5:45, the standard meridian should be 86.25 not 86 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (don’t worry about this one if it is difficult. I'll probably never use gmt 5:45
Site address |  |  |  | ???????? |  |  |  |  |  |  |  |  |  |  |  | I don't want to widen the column as that will stuff up my calendar
Longitude |  |  |  | 152 | degrees |  |  |  |  | East |  |  |  |  |  |  |  |  |  |  | I would like to do conditional formatting but don't know how to
 |  |  |  | 58 | minutes |  |  |  |  | Longitude |  |  |  |  |  |  |  | +10 |  |  | I.E. if sheet 1 cell j46 = yes then cell e7 font size is 10 and formatted to one decimal place
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GMT
 |  |  |  | 150 | degrees |  |  | STANDARD MERIDIAN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | refer to sheet 1 a43 to f76
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I tried to format as text thinking that would cure the problem
A plumb bob will caste a shadow on the north/south line at the time corresponding to the date in the table |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | It didn't
 | Jan |  |  | Feb |  |  | Mar |  |  | Apr |  |  | May |  |  | Jun |  |  | Jul |  |  | Aug |  |  | Sep |  |  | Oct |  |  | Nov |  |  | Dec
DAY | hour | min | sec | hour | min | sec | hour | min | sec | hour | min | sec | hour | min | sec | hour | min | sec | hour | min | sec | hour | min | sec | hour | min | sec | hour | min | sec | hour | min | sec | hour | min | sec
1 | 11 | 51 | 20 | 12 | 1 | 41 | 12 | 0 | 42 | 11 | 52 | 16 | 11 | 45 | 17 | 11 | 45 | 43 | 11 | 51 | 41 | 11 | 54 | 24 | 11 | 48 | 20 | 11 | 38 | 3 | 11 | 31 | 48 | 11 | 36 | 57
2 | 11 | 51 | 48 | 12 | 1 | 49 | 12 | 0 | 31 | 11 | 51 | 58 | 11 | 45 | 9 | 11 | 45 | 52 | 11 | 51 | 53 | 11 | 54 | 21 | 11 | 48 | 1 | 11 | 37 | 44 | 11 | 31 | 46 | 11 | 37 | 19
3 | 11 | 52 | 16 | 12 | 1 | 56 | 12 | 0 | 19 | 11 | 51 | 40 | 11 | 45 | 2 | 11 | 46 | 2 | 11 | 52 | 5 | 11 | 54 | 17 | 11 | 47 | 42 | 11 | 37 | 25 | 11 | 31 | 45 | 11 | 37 | 42
4 | 11 | 52 | 44 | 12 | 2 | 3 | 12 | 0 | 6 | 11 | 51 | 22 | 11 | 44 | 56 | 11 | 46 | 12 | 11 | 52 | 16 | 11 | 54 | 12 | 11 | 47 | 23 | 11 | 37 | 6 | 11 | 31 | 45 | 11 | 38 | 6
5 | 11 | 53 | 11 | 12 | 2 | 9 | 11 | 59 | 53 | 11 | 51 | 5 | 11 | 44 | 50 | 11 | 46 | 22 | 11 | 52 | 27 | 11 | 54 | 7 | 11 | 47 | 3 | 11 | 36 | 48 | 11 | 31 | 46 | 11 | 38 | 30
6 | 11 | 53 | 38 | 12 | 2 | 14 | 11 | 59 | 39 | 11 | 50 | 48 | 11 | 44 | 45 | 11 | 46 | 32 | 11 | 52 | 37 | 11 | 54 | 1 | 11 | 46 | 43 | 11 | 36 | 30 | 11 | 31 | 48 | 11 | 38 | 55
7 | 11 | 54 | 5 | 12 | 2 | 18 | 11 | 59 | 25 | 11 | 50 | 31 | 11 | 44 | 41 | 11 | 46 | 43 | 11 | 52 | 47 | 11 | 53 | 54 | 11 | 46 | 23 | 11 | 36 | 12 | 11 | 31 | 50 | 11 | 39 | 20
8 | 11 | 54 | 31 | 12 | 2 | 22 | 11 | 59 | 11 | 11 | 50 | 14 | 11 | 44 | 37 | 11 | 46 | 54 | 11 | 52 | 57 | 11 | 53 | 47 | 11 | 46 | 3 | 11 | 35 | 55 | 11 | 31 | 53 | 11 | 39 | 46
9 | 11 | 54 | 57 | 12 | 2 | 24 | 11 | 58 | 56 | 11 | 49 | 57 | 11 | 44 | 33 | 11 | 47 | 5 | 11 | 53 | 6 | 11 | 53 | 39 | 11 | 45 | 42 | 11 | 35 | 38 | 11 | 31 | 57 | 11 | 40 | 12
10 | 11 | 55 | 22 | 12 | 2 | 26 | 11 | 58 | 41 | 11 | 49 | 40 | 11 | 44 | 30 | 11 | 47 | 17 | 11 | 53 | 15 | 11 | 53 | 31 | 11 | 45 | 21 | 11 | 35 | 22 | 11 | 32 | 2 | 11 | 40 | 39
11 | 11 | 55 | 46 | 12 | 2 | 27 | 11 | 58 | 26 | 11 | 49 | 24 | 11 | 44 | 28 | 11 | 47 | 29 | 11 | 53 | 24 | 11 | 53 | 22 | 11 | 45 | 0 | 11 | 35 | 6 | 11 | 32 | 8 | 11 | 41 | 6
12 | 11 | 56 | 10 | 12 | 2 | 28 | 11 | 58 | 10 | 11 | 49 | 8 | 11 | 44 | 26 | 11 | 47 | 41 | 11 | 53 | 32 | 11 | 53 | 13 | 11 | 44 | 39 | 11 | 34 | 50 | 11 | 32 | 15 | 11 | 41 | 34
13 | 11 | 56 | 33 | 12 | 2 | 27 | 11 | 57 | 54 | 11 | 48 | 52 | 11 | 44 | 24 | 11 | 47 | 53 | 11 | 53 | 40 | 11 | 53 | 3 | 11 | 44 | 18 | 11 | 34 | 35 | 11 | 32 | 22 | 11 | 42 | 2
14 | 11 | 56 | 56 | 12 | 2 | 26 | 11 | 57 | 38 | 11 | 48 | 37 | 11 | 44 | 24 | 11 | 48 | 5 | 11 | 53 | 47 | 11 | 52 | 52 | 11 | 43 | 57 | 11 | 34 | 21 | 11 | 32 | 31 | 11 | 42 | 30
15 | 11 | 57 | 18 | 12 | 2 | 24 | 11 | 57 | 21 | 11 | 48 | 22 | 11 | 44 | 24 | 11 | 48 | 18 | 11 | 53 | 54 | 11 | 52 | 41 | 11 | 43 | 36 | 11 | 34 | 7 | 11 | 32 | 40 | 11 | 42 | 59
16 | 11 | 57 | 40 | 12 | 2 | 21 | 11 | 57 | 4 | 11 | 48 | 7 | 11 | 44 | 24 | 11 | 48 | 31 | 11 | 54 | 0 | 11 | 52 | 29 | 11 | 43 | 15 | 11 | 33 | 54 | 11 | 32 | 50 | 11 | 43 | 28
17 | 11 | 58 | 0 | 12 | 2 | 18 | 11 | 56 | 47 | 11 | 47 | 53 | 11 | 44 | 25 | 11 | 48 | 44 | 11 | 54 | 6 | 11 | 52 | 17 | 11 | 42 | 54 | 11 | 33 | 41 | 11 | 33 | 1 | 11 | 43 | 57
18 | 11 | 58 | 20 | 12 | 2 | 14 | 11 | 56 | 30 | 11 | 47 | 39 | 11 | 44 | 27 | 11 | 48 | 57 | 11 | 54 | 11 | 11 | 52 | 5 | 11 | 42 | 33 | 11 | 33 | 29 | 11 | 33 | 12 | 11 | 44 | 26
19 | 11 | 58 | 40 | 12 | 2 | 9 | 11 | 56 | 12 | 11 | 47 | 25 | 11 | 44 | 29 | 11 | 49 | 10 | 11 | 54 | 16 | 11 | 51 | 52 | 11 | 42 | 12 | 11 | 33 | 17 | 11 | 33 | 25 | 11 | 44 | 55
20 | 11 | 58 | 58 | 12 | 2 | 3 | 11 | 55 | 54 | 11 | 47 | 12 | 11 | 44 | 31 | 11 | 49 | 23 | 11 | 54 | 20 | 11 | 51 | 38 | 11 | 41 | 50 | 11 | 33 | 6 | 11 | 33 | 38 | 11 | 45 | 25
21 | 11 | 59 | 16 | 12 | 1 | 57 | 11 | 55 | 36 | 11 | 47 | 8 | 11 | 44 | 34 | 11 | 49 | 36 | 11 | 54 | 23 | 11 | 51 | 24 | 11 | 41 | 28 | 11 | 32 | 56 | 11 | 33 | 52 | 11 | 45 | 55
22 | 11 | 59 | 33 | 12 | 1 | 50 | 11 | 55 | 18 | 11 | 46 | 47 | 11 | 44 | 38 | 11 | 49 | 49 | 11 | 54 | 26 | 11 | 51 | 9 | 11 | 41 | 7 | 11 | 32 | 46 | 11 | 34 | 7 | 11 | 46 | 25
23 | 11 | 59 | 49 | 12 | 1 | 43 | 11 | 55 | 0 | 11 | 46 | 35 | 11 | 44 | 44 | 11 | 50 | 2 | 11 | 54 | 28 | 11 | 50 | 54 | 11 | 40 | 46 | 11 | 32 | 37 | 11 | 34 | 23 | 11 | 46 | 55
24 | 12 | 0 | 5 | 12 | 1 | 35 | 11 | 54 | 42 | 11 | 46 | 23 | 11 | 44 | 47 | 11 | 50 | 15 | 11 | 54 | 30 | 11 | 50 | 38 | 11 | 40 | 25 | 11 | 32 | 28 | 11 | 34 | 40 | 11 | 47 | 25
25 | 12 | 0 | 20 | 12 | 1 | 26 | 11 | 54 | 24 | 11 | 46 | 12 | 11 | 44 | 52 | 11 | 50 | 28 | 11 | 54 | 32 | 11 | 50 | 22 | 11 | 40 | 4 | 11 | 32 | 21 | 11 | 34 | 57 | 11 | 47 | 55
26 | 12 | 0 | 34 | 12 | 1 | 17 | 11 | 54 | 6 | 11 | 46 | 2 | 11 | 44 | 58 | 11 | 50 | 41 | 11 | 54 | 33 | 11 | 50 | 6 | 11 | 39 | 43 | 11 | 32 | 14 | 11 | 35 | 15 | 11 | 48 | 25
27 | 12 | 0 | 47 | 12 | 1 | 7 | 11 | 53 | 48 | 11 | 45 | 52 | 11 | 45 | 5 | 11 | 50 | 53 | 11 | 54 | 33 | 11 | 49 | 49 | 11 | 39 | 22 | 11 | 32 | 7 | 11 | 35 | 34 | 11 | 48 | 55
28 | 12 | 0 | 59 | 12 | 0 | 56 | 11 | 53 | 29 | 11 | 45 | 42 | 11 | 45 | 12 | 11 | 51 | 5 | 11 | 54 | 32 | 11 | 49 | 32 | 11 | 39 | 2 | 11 | 32 | 2 | 11 | 35 | 54 | 11 | 49 | 24
29 | 12 | 1 | 11 | 12 | 0 | 50 | 11 | 53 | 10 | 11 | 45 | 33 | 11 | 45 | 19 | 11 | 51 | 17 | 11 | 54 | 31 | 11 | 49 | 15 | 11 | 38 | 42 | 11 | 31 | 57 | 11 | 36 | 14 | 11 | 49 | 53
30 | 12 | 1 | 22 | X | X | X | 11 | 52 | 52 | 11 | 45 | 25 | 11 | 45 | 27 | 11 | 51 | 29 | 11 | 54 | 29 | 11 | 48 | 57 | 11 | 38 | 22 | 11 | 31 | 53 | 11 | 36 | 35 | 11 | 50 | 22
31 | 12 | 1 | 32 | X | X | X | 11 | 52 | 34 | X | X | X | 11 | 45 | 35 | X | X | X | 11 | 54 | 27 | 11 | 48 | 39 | X | X | X | 11 | 31 | 50 | X | X | X | 11 | 50 | 51
 | Jan |  |  | Feb |  |  | Mar |  |  | Apr |  |  | May |  |  | Jun |  |  | Jul |  |  | Aug |  |  | Sep |  |  | Oct |  |  | Nov |  |  | Dec