Change colour of 3 cells if 1 cell has a certain word

hi ppl

i have 4 rows a b c and d, in row d if i enter "network issues rack 4" in cell d3 i want it to recognise ive entered the word "rack" in that cell and cells a3 b3 c3 and d3 all turn red.
so if i enter "network issues switch 2" i want it to recognise "switch" and the cells to turn orange.

TIA
Martin

That's great, works perfectly however I have many rows, up to HH would I do this for every 4th row or is there something that could be added to the above to make this happen?

Thank you for your help

Martin

I have attached a example of what the document looks like, I hope this helps, currently I have conditional formatting set to turn the columns green when something is entered under the engineer column then with the code I need I want that to change when those words are entered into the Notes column.

Sorry I thought giving a little information would work but I get the complexity of it I should have included everything 1st so here goes.

I have set everything up how my document looks , ive hidden columns A-G as they are not important and have confidential information so I can not include.

Currently when I enter a name in the engineer column - that column plus the site, location and notes column turns green.
Empty rows are black then when something is entered into the notes column it turns yellow.

I would like to slightly change things so if the word "rack" is written in the notes column I want it to go red and orange if the word "switch" is written. if something else is written not including those words I want it to go yellow. and stay green if it is blank.

I have put an example in the second sheet of what it should look like

TIA
Martin

Without knowing the full scope, could you look at using a table with conditional formatting? I've structured the data so it's usable in a table and added the conditional formatting so it works as you ask. Take a look and let us know if this works for you? (I put the table in columns A-E and put conditional formatting in for if it found "switch" or "rack". The other colors are there only from previous conditional formatting.

Thank you both for you help, Gregb11 I never designed the document so I cant change what it already looks like as it is already in use. alansidman yours kind of works however it only formats the 1 cell not the 3 cells before it I need all four cells to change colour when the text is entered.

"I never designed the document so I cant change what it already looks like as it is already in use."
I understand. However, I would challenge that heavily. Using a table gives you so many more benefits than the design you currently have and I expect people would welcome a better design. But, I don't know the history or full requirements so who knows - good luck with it.