Spreadsheet: 678845d1590081647-conditional-formatting-using-left-in-formula-example-data
Sheet: Sheet1

 |  | - | 98E | 90T | 88E | 95E | 78E | 91T | 89T | 89E | 88I | 89I | 88R | 90R | 91I | 87I | 88I | 89I | 89T | 88I | 85C | 95R | 82C | 96R | 84C | 90I | 87C | 89C | 88C | 84C | 94R | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | - | NT | NT | - | - | - | NT | NT
 |  | - | NT | NT | 90E | 90E | 89I | 86T | 87R | 86E | 89I | 82I | 89R | 91R | 79I | 87R | 86E | 82R | 86R | 91R | 90R | 87R | 90R | 87R | 87R | 89R | 90R | 87R | 85C | 78C | 93R | 93R | 88R | 83C | 82C | 88C | 75C | 93C | 82C | 86C | 80C | 84C | 80C | - | 90R | 82C | - | - | - | 90C | 80C
 |  | - | NT | 91I | 97T | 94T | 93T | 81C | 92E | 88E | 98T | 99E | 91E | 86E | 87E | 95T | 88T | 88R | 96T | 88R | 96T | 88R | 87T | 84R | 96T | 92T | 85C | 78C | 79C | 75R | 98E | 90E | 87R | 82R | 94T | 90R | 72C | 86R | 98R | 85C | 78C | 85R | 87C | - | 84R | 89I | - | - | - | 82R | 87I
 |  | - | NT | 90I | 97T | 94T | 90T | 80C | 89E | 87E | 95T | 97E | 90E | 86E | 88E | 98T | 87T | 88I | 88T | 89E | 94T | 89R | 86T | 82R | 88T | 88E | 85C | 77C | 75C | 74R | 90E | 86E | 85R | 76R | 90T | 86R | 68C | 95R | 86R | 82R | 79C | 87R | 87R | - | 77R | 78E | - | - | - | 83R | 85R
 |  | - | NT | 92I | 97T | 96T | 93T | 81C | 91E | 86E | 99T | 98E | 91E | 87E | 87E | 96T | 88T | 88I | 87T | 88R | 97T | 88R | 94T | 86R | 86E | 89E | 88E | 86C | 75C | 74R | 90R | 89R | 89R | 84R | 89E | 90R | 79R | 89R | 88R | 84R | 78C | 88R | 88R | - | 71C | 89T | - | - | - | 86R | 87R
 |  | - | NT | 90I | 97T | 96T | 94T | 84R | 94E | 88R | 95T | 98E | 96E | 86I | 90T | 95T | 88E | 84E | 85E | 90E | 95T | 88R | 96T | 87R | 85E | 92T | 89T | 87C | 82C | 58C | 96R | 96R | 89R | 85C | 87T | 88R | 65C | 90R | 96R | 86R | 79C | 86R | 84R | - | 82R | 94R | - | - | - | 87R | 90R
 |  | - | NT | 89I | 95T | 95T | 92T | 82R | 93E | 87R | 94T | 93E | 92E | 86I | 88E | 99T | 88E | 90I | 87E | 90E | 96T | 88R | 96T | 86R | 87T | 88E | 86T | 84C | 75C | 59C | 98R | 88R | 88R | 74C | 88E | 87R | 69C | 89R | 94R | 82R | 72R | 84R | 84R | - | 82R | 85R | - | - | - | 83R | 85R
 |  | - | NT | 91E | 92E | 95E | 92E | 92E | 88E | 93E | 90R | 97E | 89R | 94R | 88R | 96R | 87R | 89R | 85R | 93R | 88E | 88E | 87E | 89E | 87E | 85E | 78E | 70C | 68C | 70C | 98R | 90R | 98R | 70R | 94R | 85R | 70C | 88R | 75R | 85R | 85R | 75R | 75R | - | 87R | 90T | - | - | - | 86R | 84R
 |  | - | 93T | 93E | 97T | 98T | 92E | 92E | 95T | 91E | 96E | 95E | 88I | 91E | 89I | 98T | 83C | 89R | 94R | 91R | 87R | 92R | 84I | 89R | 89T | 90R | 72C | 85C | 68C | 86R | 93R | 85C | 84C | 77C | 65C | 87C | 78R | 75C | 75C | 50C | 84C | 77C | 88C | - | 86C | 50C | - | - | - | 87C | 82R
 |  | - | 94T | 92E | 92E | 96T | 91E | 89E | 91E | 90E | 94E | 95E | 89I | 90E | 82I | 96T | 79C | 87T | 92R | 88R | 86R | 93R | 82C | 88R | 89R | 85R | 73C | 80C | 82R | 77C | 92R | 86C | 87C | 79C | 72C | 88C | 70C | 78C | 80C | 74C | 78C | 77C | 86R | - | 88C | 50C | - | - | - | 87C | 82C
 |  | - | 92E | 96E | 87I | 94E | 97E | 90E | 92E | 91E | 94E | 91E | 94E | 91I | 90E | 88E | 91R | 84R | 92R | 86C | 88C | 89C | 84C | 89C | 92C | 93C | 77C | 72C | 90C | 70C | 87C | 90C | 82R | 79C | 82C | 89C | 80C | 85C | 88C | 86C | 75C | 88C | 88C | - | 86C | 65C | - | - | - | 88C | 83C
 |  | 94E | 93E | 95E | 95I | 90I | 93R | 86R | 90R | 91R | 93R | 97R | 86R | 85R | 89R | 95R | 81C | 93R | 86C | 75C | 91R | 89R | 84C | 87C | 82C | 87C | 85C | 80C | 77C | 88C | 86C | 92C | 86C | 85C | 84C | 87C | 75C | 86C | 75C | 83C | 60C | 80C | 84C | - | NT | NT | - | - | - | NT | NT
 |  | - | NT | NT | NT | NT | 92E | 95T | 96T | 87R | 89R | 92R | 99T | 80R | 86R | 88I | 90T | 88I | 95T | 88R | 92R | 92R | 93R | 90I | 97T | 95T | NT | 88E | NT | NT | 93R | 95R | 95R | NT | NT | 95R | NV | NT | 94R | NT | NT | 95R | NT | - | 94R | 93R | - | - | - | 93C | 88C
 |  | - | 93E | 91I | 93T | 94T | 93E | 90I | 93E | 91R | 94E | 90R | 91T | 91I | 90E | 96R | 92R | 94R | 93R | 85R | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | - | NT | NT | - | - | - | NT | NT
 |  | - | NT | 91T | 92E | 93T | 87E | 88E | 88I | 91E | 94T | 91R | 87R | 93R | 90I | 88R | 88R | 87I | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | - | NT | NT | - | - | - | NT | NT
 |  | - | NT | 91T | 92E | 93T | 88E | 94T | 89E | 91E | 94T | 91R | 87R | 92R | 90I | 88R | 88R | 87I | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | - | NT | NT | - | - | - | NT | NT
 |  | - | NT | NT | 88E | NT | 91R | 80I | 83E | 86R | 92T | 88I | 90I | 84I | 83E | 94E | 82C | 82R | 96R | 82C | 84R | 84R | 84C | 88C | 91R | 88C | 87C | 86C | 80C | 75C | 90R | 92R | 88C | 87C | 87R | 88C | 68C | 84C | 84C | 82C | 72C | 83C | 85C | - | NT | NT | - | - | - | NT | NT
 |  | - | NT | NT | 88E | NT | 88E | 78E | 82E | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | - | NT | NT | - | - | - | NT | NT
 |  | - | NT | 95T | 92E | 97T | 87E | 89T | 91E | 92E | 97T | 98T | 79I | 89E | 92E | 89R | 85C | 96R | 78C | 89R | 87E | 95T | 90T | 90E | 86R | 90T | 88C | 58C | 78R | 92R | 92R | 92T | 92R | 86R | 84C | 90R | 75E | 89C | 85C | 75C | 83C | 87C | 98R | - | 82R | 73C | - | - | - | 84R | 90C
 |  | - | NT | 94T | 98E | 93T | 87E | 88E | 92E | 88R | 98T | 93E | 86R | 98E | 92R | 95T | 88R | 90I | 58C | 96T | 98E | 90E | 98E | 82C | 82C | 90T | 86C | 85C | 78C | 65C | 95R | 94T | 88R | 60C | 78C | 88R | 72C | 87C | 70C | 88C | 77C | 88C | 97R | - | 75C | 60C | - | - | - | 82C | 88C
 |  | - | 89R | 91T | 93E | 95R | 78I | 79I | NT | 95R | 89I | 95I | 82I | 92R | 95I | 94R | 92R | 91I | 91R | 91R | 76C | 86E | 92T | 88R | 91T | 90R | 94R | 91R | 87C | 88R | 96R | 91C | 92R | 84C | 85C | 88R | 70R | 89R | 78C | 86R | 68I | 88R | 70R | - | 92C | 95R | - | - | - | 98R | 85R
 |  | - | NT | NT | 90E | 92R | 81I | 83I | 90T | 94R | 87I | 93R | 88R | 92R | 86I | 92R | 93T | 89I | 92R | 95R | 69C | 87E | 93T | 87R | 91T | 86C | 87R | 88R | 85C | 87R | 96R | 90C | 90R | 84R | 84C | 86C | 70R | 87C | 76C | 87R | 70I | 86R | 70R | - | 91C | 92R | - | - | - | 98C | 87R
 |  | - | 92R | 91R | 88R | NT | NT | 91I | 89E | 90T | 87T | 91T | 87E | 88R | 89R | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | - | NT | NT | - | - | - | NT | NT
 |  | - | NV | 86E | 94T | 92T | 87I | 92R | 89R | 89R | 96R | 94R | 92R | 94R | 94R | 91R | 92R | 75C | 70C | 91R | 92R | 93R | 93R | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | - | NT | NT | - | - | - | NT | NT
 |  | - | 89I | 87I | 95R | 92C | 86C | 90C | 88C | 87C | 94C | 92C | 91C | 93C | 93C | 90C | 92C | 80C | 78C | 88C | 90C | 90C | 85C | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | - | NT | NT | - | - | - | NT | NT
 |  | - | NV | 88T | 95T | 91T | 90I | 93T | 88E | 88E | 95T | 94T | 90T | 93T | 95T | 91R | 93R | 82I | 70C | 96R | 94R | 92R | 92T | 93E | 97T | 87C | 77C | 89E | 74C | 76C | 96R | 97T | 90R | 86R | 89I | 95R | 65C | 75C | 96R | 80R | 88I | 89R | 97T | - | NT | NT | - | - | - | 94R | 93R
 |  | - | NV | NV | 97T | 93T | 89I | 94T | 89E | 89E | 98T | 95T | 91T | 95T | 97T | 93R | 95R | 83I | 73C | 96R | 95R | 95T | 92T | 93E | 97T | 87R | 77C | 91R | 74C | 76C | 96R | 97T | 90R | 86R | 90I | 95R | 65C | 75C | 96R | 80R | 88I | 90R | 97T | - | NT | NT | - | - | - | 94R | 93C
 |  | - | 89I | 90I | 95R | 93C | 87C | 91C | 88C | 88C | 93C | 92C | 90C | 92C | 93C | 88C | 93C | 82C | 79C | 92C | 95C | 90C | 85C | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | - | NT | NT | - | - | - | NT | NT
 |  | - | 88T | 87E | 96T | 95T | 86E | 95R | 89R | 88R | 94R | 97R | 92R | 94R | 97R | 93C | 95R | 78C | 70C | 94R | 92R | 94R | 88R | 94R | 89R | 90R | NT | NT | NT | NT | 90R | NT | 90R | NT | NV | 93R | NT | NT | NT | NT | NT | NT | NT | - | NT | NT | - | - | - | NT | NT
 |  | - | NV | NV | 98T | 97T | 87E | 97T | 88R | 89R | 98T | 93T | 93R | 96R | 97R | 88R | 95R | 77C | 70C | 94R | 93R | 95T | 88R | 95R | 88R | 93R | NT | 90R | NT | NT | 94R | NT | 94R | NV | NV | 93R | NT | 92R | 92R | NT | NT | NT | NT | - | NT | 93R | - | - | - | NT | NT
 |  | - | 88T | 87E | 97T | 95R | 88R | 96R | 89R | 88R | 96R | 94R | 90R | 93R | 96R | 89R | 95C | 79C | 72C | 93R | 90R | 94R | 88R | 95R | 88R | 89R | NT | 89R | NT | NT | 90R | NT | 92R | NT | NV | 93R | 60C | NT | 90R | NT | NT | NT | NT | - | NT | 92R | - | - | - | NT | NT
 |  | - | 86T | 91T | 92I | 92R | 94R | 88R | 92R | 91R | 88R | 89R | 90C | 91R | 90R | 91I | 92C | 87C | 70C | 88C | 88C | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | - | NT | NT | - | - | - | NT | NT
 |  | - | 88T | 88E | 94T | 94R | 88I | 94R | 89R | 87R | 94R | 92R | 90R | 94R | 93R | 90R | 94R | 78C | 75C | 91C | 88C | 89C | 89C | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | - | NT | NT | - | - | - | NT | NT
 |  | - | NT | 95T | 92T | 92T | 84E | 89E | 88R | 94T | 88R | 91R | 89R | 93R | 83C | 90R | 93R | 89R | 79I | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | - | NT | NT | - | - | - | NT | NT
 |  | - | NT | 97T | 93T | 91T | 83E | 89E | 88E | 98T | NT | 91T | 89R | 96T | NT | NT | NT | 90T | NT | NV | 92R | NV | NV | 89T | NT | 92T | 92T | NT | 95E | 90E | NV | NV | NV | NV | NV | 92R | NV | 92R | 86R | NV | 84R | NV | 83C | - | NV | 82R | - | - | - | NV | 90R
 |  | - | 94T | 93E | 95T | 94E | 91T | 90I | 92T | 88T | 95T | 92R | 90R | 89R | 85R | 92R | 95E | 87I | 76C | 94R | 86E | 86E | 82C | 86R | 85R | 90R | 90R | 87R | 85R | 76R | 87R | 90R | 87R | 82C | 82R | 82C | 78R | 74C | 92C | 92C | 75C | 79C | 84C | - | 86R | 84C | - | - | - | 74C | 90C
 |  | - | 95T | 90I | 96I | 92T | 93E | 90I | 93T | 89T | 96E | 94R | 91R | 90R | 88R | 93T | 95E | 88I | 78C | 95R | 87C | 88C | 88T | 86R | 92R | 90R | 90R | 87R | 82R | 74R | 89R | 88C | 87C | 88C | 77C | 85C | 86R | 85C | 87C | 84C | 85C | NT | NT | - | NT | NT | - | - | - | NT | NT
 |  | - | 94T | 92T | 94R | 92E | 93E | 97E | 91R | 88E | 95R | 90R | 91I | 90R | 88R | 94R | 94R | 90I | 89R | 95R | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | - | NT | NT | - | - | - | NT | NT
 |  | - | NT | 91I | 90E | 93R | 90E | 85E | 91E | 88E | 91E | 91R | 90R | 89R | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | 86R | NT | NT | NT | NT | NT | NT | - | NT | NT | - | - | - | NT | NT
 |  | - | - | 86I | 98T | 97E | 93R | 98T | 96E | 82I | 95T | 94T | 94T | 96E | 91E | 95T | 91R | 92I | 95E | 96T | 78C | 88T | 85R | 94I | 90T | 94T | 95E | 90E | 93R | 94T | 94E | 84E | 75E | 90E | 90R | 90T | 92R | 76C | 86R | 85R | 87R | 80R | 92R | - | 90T | 85R | - | - | - | 70C | 92R
 |  | - | - | 94E | 94E | 96E | 94R | 93R | 94E | 88I | 91E | 90R | 88I | 92R | 87I | 94E | 92R | 91R | 90R | 90C | 87C | 89R | 89R | 92C | 87C | 92C | 88C | 90C | 92C | 85C | 90C | 76C | 89C | 75C | 90C | 84C | 88C | 85C | 85C | 86C | 88C | 83C | 86C | - | 80C | 86C | - | - | - | 82C | 83C
 |  | - | NT | 92R | 93R | 90I | 93R | 92R | 92R | 74I | 90R | 85I | 78I | 88R | 79I | 78I | 82I | 93R | 85R | 90R | 83C | 87C | 86C | 85C | 89C | 87C | 92C | 90C | 90C | 91C | 91C | 83C | 82C | 90C | 87C | 88C | 88C | 78C | 80C | 82C | 82C | 83C | 86C | NT | 87C | 80C | NT | NT | NT | 60C | 89C
 |  | - | NT | 90R | 91R | 87I | 94R | 90R | 93R | 84I | 91R | 90R | 86I | 90I | 87I | 90R | 89I | 90R | 92R | 92R | 88R | 90C | 89C | 90C | 88C | 88C | 92C | 88C | 88C | 86C | 86C | 85C | 87C | 86C | 84C | 86C | 85C | 85C | 84C | 83C | 85C | 80C | 84C | NT | NT | NT | NT | NT | NT | NT | NT
 |  | - | NT | 90I | 92T | 87I | 93E | 94R | 90E | 88E | 92T | 87R | 88I | 94E | 92E | 92R | 94R | 92R | 93R | 89R | 92R | 88R | 90R | 90R | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT
 |  | - | NT | 90I | 92R | 87I | 94R | 93R | 93R | 87R | 92R | 87R | 88I | 94R | 92R | 92R | 94R | 92R | 93R | 89R | 92R | 88C | 90C | 90C | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT
 |  | NT | NT | 90E | 94T | 93R | 92R | 87R | 92R | 90R | 88I | 86R | 94T | 84T | 91E | 85T | 86E | 88E | 92I | 85E | 86E | 92E | 89T | 87C | 83C | 76C | 92R | 89R | 88R | 87C | 90C | 86C | 88C | 72C | 85C | 87C | 65C | 90C | 84C | 86C | 86C | NT | NT | - | NT | NT | - | - | - | NT | NT
 |  | NT | NT | 93T | 90E | 86I | 94T | 92T | 95T | 87E | 92T | 92T | 91T | 95R | 91R | 94R | 91R | 90R | 89R | 92R | 89R | 90T | 90T | 88T | 88T | 87R | 90R | 87R | 89R | 85C | 87R | 92R | 88R | 90R | 78R | 86R | 72C | 92R | 78C | NT | NT | NT | NT | - | NT | NT | - | - | - | NT | NT
 |  | - | 95E | 92E | 96I | 92I | 92R | 95R | 91R | 94R | 92R | 90R | 91R | 92R | 94R | 93R | 91R | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | - | - | - | NT | NT
 |  | - | NT | 89T | 91T | 94T | 87R | 94T | 94T | 79I | 96T | 89T | 85I | 85R | 94R | 96R | 94R | 90C | 95R | 95C | 88C | 88E | 95E | 88R | 90E | 87R | 90R | 87R | 87R | 89R | 88R | 88C | 85C | 87C | 90R | 86C | NT | 76R | 83C | 85C | 88C | NT | NT | - | NT | NT | - | - | - | NT | NT
 |  | - | NT | 90T | 92T | 91T | 90T | 91T | 91T | 90T | 92R | 89R | 92R | 87R | 82I | 91R | 88R | 89R | 90R | 90C | 88E | 89R | 90R | 87R | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | - | NT | NT | - | - | - | NT | NT
 |  | - | NT | 88T | 85I | 89I | 94T | 81I | 78I | 82I | 89R | 85I | 79I | 90R | 84R | 87R | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | 84R | NT | NT | NT | NT | NT | NT | - | NT | NT | - | - | - | NT | NT
 |  | - | NT | 87T | 91T | 93T | 90T | 93E | 94T | 78I | 92T | 87I | 85R | 85I | 93R | 91R | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | - | NT | NT | - | - | - | NT | NT
 |  | - | 96E | 91E | 93I | 92E | 91I | 93R | 87R | 92R | 90E | 88R | 90R | 88R | 89R | 90R | 89R | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | - | NT | NT | - | - | - | NT | NT
 |  | - | - | 84E | 85E | 86E | 90E | 91R | 82I | 88R | 91R | 89R | 81I | 91R | 90R | 85C | 83C | 78C | 87C | 76C | 81I | 80I | 90R | 86I | 89R | 84I | 87R | 83C | 86I | 86C | 85C | 88C | 80C | 77C | 85C | 82C | NT | 85C | 78C | 74C | 69C | NT | NT | - | NT | NT | - | - | - | NT | NT
 |  | NT | NT | 96E | 91R | 96E | 92E | 93R | 91E | 89I | 91R | 93R | 88R | 90R | 92R | 87R | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | NT | - | NT | NT | - | - | - | NT | NT