# conditional Formatting Maybe?

#### McKfodder

##### New Member
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

### Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

#### steve the fish

##### Well-known Member
In I14 place the conditional formatting formula:

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

or something similar and apply it to:

=\$I\$14:\$L\$14

#### McKfodder

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

#### McKfodder

##### New Member
Actual sorted it thank you so much big help

Replies
2
Views
443
Replies
10
Views
1K
Replies
3
Views
689
Replies
3
Views
401
Replies
3
Views
454

Threads
1,191,118
Messages
5,984,749
Members
439,907
Latest member
Kayfabe

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back