Trying to add conditioning and values based on multiple conditions.

Macresponse form.xlsx

I have tried several things to make this work and none of them are working, I am trying to stay away from programming a macro because this will be used by multiple people who tend to disable them and that would keep it from working. But I may have no choice as I can’t seem to get it to work.
3 sheets :: User, Tech, Admin(data)
The premise of what I’m trying to accomplish is the have it so when a user selects a machine to be down it turns red (conditional formatting) when they select reduced it turns Tan (conditional formatting). But also it then checks to see what kill and threat groups the equipment belongs to. If some other equipment belongs in that kill group then it would turn orange to the user and if it belongs to the threat group it turns yellow.
For instanced If Elevator goes down the User screen should turn Red on the elevator and yellow on All Mac's. If the air compressor went down the Air compressor would turn red and all Mac's would turn yellow.
The information admin is for calculation use and for making a pilot table. I have truncated the document to make it less cumbersome for my own testing. I can see that writing a script that reacts to the user changing the status but I'm trying to avoid doing that. Is there something I'm missing that just making my world a pain?
one thing that is throwing me for a look is that when I try to use mid(,search(),len()) it returns the word that I want to see when I'm comparing but for some reason thee statement if(mid(,search(),len)) = "", True, False) only produces true when they value in the cell Mid looks at is correct and if it's not it displays #Value! and not false.

Pl ty this formula.

=IF(ISERROR(FIND(A1,A2)),FALSE,TRUE)