Excel

In a new column too the righ, put the fomular If Column B is: 4800= Langley 5000=Elmendorf 5260 = Hickam 6530= Hickam 4852=Nellis 2823-Eglin 4819-Tindall 2850-Edwards If its none of those numbers above = "NA" In Column L:Condition Formatting Highlight in GREEN COLOR all "1A" and "JA"