I need to figure how to get a certain cell to turn the color I want based on select cell having a certain word in them. I was trying something like this but it would not let do it.

=$E2,$E5,$E6="NMC"


I understand that this is not the proper formula. Any help would be appreciated.