Can these 2 formulas be merged in to 1

[Toonies]

Hi and thank you for taking time ou to look at my question


I have the following 2 formulas which work fine on their own

Excel Workbook
	A	B	C	D	E	F	G	H
5
6	COLLEAGUE NAME		DEPARTMENT		SHIFT			06:00
7								|
8								06:30
9
10	ANDREA ALLEN				8:00	17:00		REVERSE PICK
11								0
Master Schedule

I am wondering is there any way to merge them into one

I look forward to any suggestions or pointers if it is possible.

 

[jasonb75]

From your original sample, I would guess that the cells to highlight are in a non-contiguous range, in which case your original method is probably more practical.

 

[Toonies]

Hi thank you for taking the time to look and you help, if anyone else can assist

 

[Toonies]

Hi This thread is "SOLVED"

Many thanks to jasonb75