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.
<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
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 |
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