conditional Formatting Maybe?

[McKfodder]

Good Morning and Happy New Year.

I am not sure what I am asking is possible I am a bit of a newbie at this but here goes.

I am trying to colour 4 cells next to each the same colour if the text SP is imputed in 1 of them is that possible.


so these cells represent Monday on a roster. Start time I14, finish time J14, turn number K14, total hours worked L14. I14,J14,K14,L14 are the 4 cell group that I would like to colour K14 is where the information SP is.

13:30

23:25

SP 13:30

09:55

12:03

20:08

NN962

08:05

RD

RD

14:31

22:35

NN964

08:04

12:00

21:55

SP 12:00

09:55

<colgroup><col width="179" style="width: 134pt; mso-width-source: userset; mso-width-alt: 6546;" span="2"> <col width="179" style="width: 134pt; mso-width-source: userset; mso-width-alt: 6546;"> <col width="179" style="width: 134pt; mso-width-source: userset; mso-width-alt: 6546;" span="21"> <tbody> </tbody>

This is one line the first 4 boxes are L14,J14,K14,L14. K14 is the line we input the others vlookup and fill the data in auto. I would like to input K14 and to colour all 4 boxes if SP is present. I have 36 lines on 6 rosters
its a pain to have to colour them each cell at a time. I can get K14 to colour but was just trying to do all 4

Any help greatly received and if you need more info just ask Im not great at explaining

 

[steve the fish]

In I14 place the conditional formatting formula:

=LEFT($K14,2)="SP"

or something similar and apply it to:

=$I$14:$L$14

 

[McKfodder]

Thanks very much that works for the 4 cells. Is their any way I can get This to work for the whole sheet

 

[McKfodder]

Actual sorted it thank you so much big help