Spreadsheet: 798196d1664363534-quick-conditional-formatting-example-etaf
Sheet: Flights

Local Departure | [NAME] | Rank | Country | Region | Aircraft Type | GA | [NAME] | Departure Time | NM | KM | ETE | TZ | [NAME] | [NAME] |  | Departure | NM | KM | ETE | TZ | [NAME] | [NAME] |  | Departure | NM | KM | ETE | TZ | [NAME] | [NAME] |  | Departure | NM | KM | ETE | TZ | [NAME] | [NAME]
 |  |  | Suriname |  | A340-300 |  | Johan Adolf Pengel International Airport |  | 8557.7 |  |  |  |  |  |  |  | 100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sydney
 |  |  | Kuwait |  | 747-8 |  | Kuwait City |  | 6960.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sydney
 |  |  | Saudi Arabia |  | 747-400 |  | Riyadh |  | 6906.9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sydney
 |  |  | Ethiopia |  | 787-8 |  | Addis Ababa |  | 6819.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sydney
 |  |  | Bahrain |  | 747-400 |  | Bahrain International Airport |  | 6754.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sydney
 |  |  | Turkmenistan |  | 777-200LR |  | Ashgabat International Airport |  | 6723 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sydney
 |  |  | Qatar |  | 747-8 |  | Doha |  | 6681.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sydney
 |  |  | Kenya |  | 777-300ER |  | Nairobi |  | 6558.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sydney
 |  |  | United Arab Emirates |  | 787-9 |  | Abu Dhabi International Airport |  | 6510.2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sydney
 |  |  | Morocco |  | 747-8 |  | Casablanca |  | 6435.6 |  |  |  |  | Singapore Airport |  |  | 3395.8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sydney
 |  |  | Portugal |  | A330-200 |  | Lisbon |  | 6425.3 |  |  |  |  | Singapore Airport |  |  | 3395.8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sydney
 |  |  | Oman |  | 747-400 |  | Muscat |  | 6312.6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sydney
 |  |  | Zimbabwe |  | 767-200ER |  | Harare |  | 6189.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sydney
 |  |  | Nigeria |  | G550 |  | Murtala Muhammed International Airport |  | 8387.7 |  |  |  |  | Singapore Airport |  |  | 3395.8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sydney
 |  |  | South Africa |  | BBJ |  | Pretoria |  | 4510.2 |  |  |  |  | Perth Airport |  |  | 1773.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sydney
 |  |  | Algeria |  | A340-500 |  | [NAME] |  | 5876 |  |  |  |  | Singapore Airport |  |  | 3395.8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sydney
 |  |  | United Kingdom |  | A330 |  | London Stansted |  | 5847.7 |  |  |  |  | Singapore Airport |  |  | 3395.8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sydney
 |  |  | Eswatini |  | A340-300 |  | King Mswati III International Airport |  | 5819.9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sydney
 |  |  | France |  | A330-200 |  | Paris |  | 5797.56 |  |  |  |  | Singapore Airport |  |  | 3395.8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sydney
 |  |  | [NAME] |  | BBJ |  | [NAME] International Airport |  | 5706.4 |  |  |  |  | Bangkok Airport |  |  | 4051 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sydney
 |  |  | Gabon |  | Global Express XRS |  | Léon-Mba International Airport |  | 5681.1 |  |  |  |  | Singapore Airport |  |  | 3395.8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sydney
 |  |  | Netherlands |  | 777-200ER |  | Amsterdam |  | 5678.3 |  |  |  |  | Singapore Airport |  |  | 3395.8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sydney
 |  |  | International Olympic Committee |  | GV |  | Geneva Airport |  | 5673.7 |  |  |  |  | Singapore Airport |  |  | 3395.8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sydney
 |  |  | Monaco |  | Falcon 7x |  | Nice |  | 5643.9 |  |  |  |  | Singapore Airport |  |  | 3395.8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sydney
 |  |  | In this situation i will need each column with the heading "NM" to be the column that the formatting is applied to. For each row, Columns J, R, Z, AH, to highlight if the value in that column associated with the corresponding word (aircraft) in the same row of column F is less than the value in each of the above mentioned columns. The values are listed against each word/aircraft listed in the 2nd tab  =VLOOKUP($F$2,Aircraft!$A$2:$C$63,3,FALSE) is the current formula im using but i cant drag it down the column as it doesnt make sure the calculation is based on that specific row itself