Runways are given a number between 01 and 36. This indicates the runway’s heading: A runway with the number 36 points to the north (360°), runway 09 points east (90°), runway 18 is south (180°), and runway 27 points west (270°). Thus, the runway number is one tenth of the runway centerline’s magnetic azimuth, measured clockwise from the magnetic declination.
I was recently flying over Omar N. Bradley airport in Moberly, MO and noted that its runway was numbered 31/13. I assumed that there were a runways where each direction would be a mirror of the digits of the other direction, but a quick glance around the compass proved me wrong. I then hypothesized that 310 and 130 were the only such directions. My dad quickly found that 200 and 20 (displayed as 20 and 02) was another. This is what weird people do. But particularly weird people make a spreadsheet.
Yep, those are the only two. Column A is the numbers 1-36 formatted as “00?. Column B has the formula
The conditional formatting for A2:B37 has this formula
Is there a better way to test that?