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

True north from gian |  | This page is ref only
 | Mitchelton Australia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SEC
 | -27 deg 28 min lat | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 12 | 3 | 29 |  |  |  |  |  | 0 | 43409 | -43409
 | 152 deg 58 min long |  |  |  |  |  |  |  |  |  |  |  | 90 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 12 | 3 | 38 |  |  |  |  |  | 0 | 43418 | -43418
 | jan 1       11:51:36 |  |  |  |  | 16 |  |  |  |  |  |  | 52 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | june 30    11:51:45 |  |  |  |  | 16 |  |  |  |  |  |  | 38
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42699 |  |  | IF(N2<=0,0,1)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G |  |  | H |  |  | I |  |  |  | J |  |  | K |  |  | L |  |  | M |  |  | N |  |  | O |  |  | P
 | Brisbane Australia
 | -27 deg 28 min lat |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mar |  |  | Apr |  |  | May |  |  | Jun |  |  | Jul |  |  | Aug |  |  | Sep |  |  | Oct |  |  | Nov |  |  | Dec
 | 153 deg 1 min long | gmt+10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sec |  |  | sec |  |  | sec |  |  | sec |  |  | sec |  |  | sec |  |  | sec |  |  | sec |  |  | sec |  |  | sec
 | jan 1       11:51:24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A
 | june 30   11:51:33 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A
 | Perth Australia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A
 | -27deg 57 min lat |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A
 | 115 deg 51 min long | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A
 | jan 1       12:20:07 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A
 | june 30    12:20:14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A
 | (don't know what town) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A
 | - 35 lat |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A
 | 135 long |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A
 | jan 1       12:03:29 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A
 | june 30    12:03:38 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A
 | San Fransisco |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A
 | 37 deg 46 min lat |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A
 | -122deg 25 min long | gm-8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A
 | jan 1        12:13:30 |  |  |  |  | 38 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A
 | june 30     12:13:26 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A
 | (don't know what town 2) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A
 | 38 deg 10 min lat |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A
 | -120 long |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A
 | jan 1       12:03:49 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A
 | june 30    12:03:46 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A
 | 11 west
 | 165 long | 12 | 3 | 45 |  | 33
 | 166deg 17 min long | 12 | 8 | 53
 | 164deg 58 min long | 12 | 3 | 37