Filter Non AOR

[Lopez106]

Good afternoon,

I am once again asking fore help on a spread sheet.
i am trying to have the cell turn black if the name in M2 is not on the list in the distance tab.
ill post screen shots of both tabs and thanks again in advance.

 

[Cubist]

Select the range you want to apply the conditional formatting.
Conditional formatting -> Use formula to determine -> Insert:

=AND(M2<>"",COUNTIFS(Distance!$I$2:$K$28,M2)=0)

Format the fill and font as black -> OK.