color code

kenpcli · Jan 3, 2018

<o

>I need a macro that will look down column F and look for the criteria below and then look at column M and put a different color for each pay class that meets the criteria.

Please use a different color foreach Pay Class in the total column:<o

></o

>

Part Time- anything over 23.99 hours<o

></o

>

2/3 – anything under 24 or over 29.99<o

></o

>

3/4 – anything under 30 or over 39<o

></o

>

Fulltime- anything below 40<o

></o

>

Also please change Home site 1to 00

Please use a different color for each Pay Class in the total column:
Part Time- anything over 23.99
2/3 – anything outside 24-29.99
3/4 – anything outside of 30-39
Fulltime- anything below 40

Also please change Home site 1 to 00

Each sheet will be called something different, so please have the macro run on the active sheet.

Home Company	Full Name	ID Number	Home Site	Home Department	Pay Class Name	Regular	Overtime	PTO	FTO	REGPOR	PORSL	Total
PCLI-Corp			1	30	FT Hourly	40.00						40.00
PCLI-Corp			1	30	FT Hourly	39.95						39.95
PCLI-Corp			1	30	FT Hourly	40.00						40.00
PCLI-Corp			1	30	FT Hourly	39.75						39.75
PCLI-Corp			1	30	FT Hourly	26.80		13.20				40.00
PCLI-Corp			1	30	FT Hourly	40.00						40.00
PCLI-Corp			1	30	FT Hourly	31.25		8.75				40.00
PCLI-Corp			1	30	FT Hourly	40.00						40.00
PCLI-Corp			1	30	Hourly PT
PCLI-Corp			1	30	Hourly PT
PCLI-Corp			1	30	Hourly PT	5.10						5.10
PCLI-Corp			1	32	FT Hourly	40.00						40.00
PCLI-Corp			1	34	FT Hourly			5.55				5.55
PCLI-Corp			1	34	Hourly 2/3	31.85						31.85
PCLI-Corp			1	36	FT Hourly	40.00	0.25					40.25
PCLI-Corp			1	36	FT Hourly	40.00	0.60					40.60
PCLI-Corp			1	36	FT Hourly	31.25		8.75				40.00
PCLI-Corp			1	36	FT Hourly	40.00	0.45					40.45
PCLI-Corp			1	36	FT Hourly	35.25		4.75				40.00
PCLI-Corp			1	36	FT Hourly	23.70		16.30				40.00
PCLI-Corp			1	36	FT Hourly	38.40		1.60				40.00
PCLI-Corp			1	36	FT Hourly	38.20		1.80				40.00
PCLI-Corp			1	38	FT Hourly	40.00	5.25					45.25
PCLI-Corp			1	38	FT Hourly	33.60		6.40				40.00
PCLI-Corp			1	38	FT Hourly	40.00	1.20					41.20
PCLI-Corp			1	38	FT Hourly	31.55		8.45				40.00
PCLI-Corp			1	38	FT Hourly	38.00		2.00				40.00
PCLI-Corp			1	38	FT Hourly	26.70		10.00				36.70
PCLI-Corp			1	38	FT Hourly	40.00	1.65					41.65
PCLI-Corp			1	38	FT Hourly	28.90		10.00				38.90
PCLI-Corp			1	38	Hourly 2/3	31.65						31.65
PCLI-Corp			1	38	Hourly 2/3	30.25						30.25
PCLI-Corp			1	38	Hourly 2/3	35.75						35.75
PCLI-Corp			1	38	Hourly 2/3	27.05						27.05
PCLI-Corp			1	38	Hourly PT	4.85						4.85
PCLI-Corp			1	38	Hourly PT	7.25						7.25
PCLI-Corp			1	38	Hourly PT	16.25						16.25
PCLI-Corp			1	38	Hourly PT	7.05						7.05
PCLI-Corp			1	38	Hourly PT	17.75						17.75
PCLI-Corp			1	38	Hourly PT	22.55						22.55
PCLI-Corp			1	38	Hourly PT	21.85						21.85
PCLI-Corp			1	38	Hourly PT	11.75						11.75
PCLI-Corp			1	38	Hourly PT	7.70						7.70
PCLI-Corp			1	38	Hourly PT					11.90		11.90
PCLI-Corp			1	38	Hourly PT
PCLI-Corp			1	38	Hourly PT
PCLI-Corp			1	38	Hourly PT	10.25						10.25
PCLI-Corp			1	38	Hourly PT	11.35						11.35
PCLI-Corp			1	38	Hourly PT	22.85						22.85
PCLI-Corp			1	38	Hourly PT	20.45						20.45
PCLI-Corp			1	38	Hourly PT	22.50						22.50
PCLI-Corp			1	38	Hourly PT	9.85						9.85
PCLI-Corp			1	38	Hourly PT	16.45						16.45
PCLI-Corp			1	38	Hourly PT	11.75						11.75
PCLI-Corp			1	38	Hourly PT	22.45						22.45
PCLI-Corp			1	38	Hourly PT	26.20						26.20
PCLI-Corp			1	38	Hourly PT	27.70						27.70
PCLI-Corp			1	38	Hourly PT	38.15						38.15
PCLI-Corp			1	38	Hourly PT
PCLI-Corp			1	38	Hourly 3/4	30.80						30.80
PCLI-Corp			1	38	Hourly 3/4	31.35						31.35
PCLI-Corp			1	38	Hourly 3/4	33.05						33.05
PCLI-Corp			1	38	Hourly 3/4
PCLI-Corp			1	38	Hourly 3/4			30.00				30.00
PCLI-Corp			1	38	Hourly 3/4	36.05						36.05
PCLI-Corp			1	38	Hourly 3/4			30.00				30.00
PCLI-Corp			1	42	FT Hourly	40.00	0.35					40.35
PCLI-Corp			1	42	FT Hourly	40.00	0.05					40.05
PCLI-Corp			1	42	FT Hourly	40.00	0.20					40.20
PCLI-Corp			1	42	FT Hourly			40.00				40.00
PCLI-Corp			1	46	FT Hourly	35.30						35.30
PCLI-Corp			1	46	FT Hourly	40.00						40.00
PCLI-Corp			1	46	FT Hourly	38.65						38.65
PCLI-Corp			1	46	FT Hourly	30.30						30.30
PCLI-Corp			1	48	FT Hourly	32.00		8.00				40.00
PCLI-Corp			1	50	FT Hourly	40.00	0.05					40.05
PCLI-Corp			1	50	FT Hourly	40.00	0.10					40.10
PCLI-Corp			1	50	FT Hourly	40.00	9.65					49.65
PCLI-Corp			1	50	FT Hourly	37.40		2.60				40.00
PCLI-Corp			1	50	FT Hourly	33.55						33.55
PCLI-Corp			1	50	FT Hourly	17.40		22.60				40.00
PCLI-Corp			1	50	FT Hourly	37.25						37.25
PCLI-Corp			1	50	FT Hourly	40.00						40.00
PCLI-Corp			1	50	FT Hourly	40.00	0.15					40.15
PCLI-Corp			1	50	FT Hourly	40.00	0.05					40.05
PCLI-Corp			1	52	FT Hourly	36.35						36.35
PCLI-Corp			1	52	FT Hourly	40.00	2.30					42.30
PCLI-Corp			1	54	FT Hourly	30.00		10.00				40.00
PCLI-Corp			1	54	FT Hourly	37.90		2.10				40.00
PCLI-Corp			1	54	FT Hourly	10.55		29.45				40.00
PCLI-Corp			1	54	FT Hourly	40.00	2.25					42.25
PCLI-Corp			1	54	FT Hourly	30.40		9.60				40.00
PCLI-Corp			1	54	FT Hourly	40.00	7.10					47.10
PCLI-Corp			1	54	FT Hourly	40.00	0.10					40.10
PCLI-Corp			1	54	FT Hourly	40.00	0.05					40.05
PCLI-Corp			1	54	FT Hourly	40.00	1.30					41.30
PCLI-Corp			1	54	Hourly 2/3	19.25		4.75				24.00
PCLI-Corp			1	55	FT Hourly	18.15		21.85				40.00
PCLI-Corp			1	55	FT Hourly	40.00	0.60					40.60
PCLI-Corp			1	55	FT Hourly	36.60		3.40				40.00
PCLI-Corp			1	55	FT Hourly	35.55		4.45				40.00
PCLI-Corp			1	55	FT Hourly	39.95						39.95
PCLI-Corp			1	55	Hourly PT	34.20						34.20
PCLI-Corp			1	56	FT Hourly	37.00		3.00				40.00
PCLI-Corp			1	56	FT Hourly	15.50		24.50				40.00
PCLI-Corp			1	56	FT Hourly	34.55		5.45				40.00
PCLI-Corp			1	56	Hourly 3/4	36.80						36.80
PCLI-Corp			1	60	FT Hourly	40.00	0.20					40.20
PCLI-Corp			1	60	FT Hourly	40.00						40.00
PCLI-Corp			1	60	FT Hourly	40.00	0.05					40.05
PCLI-Corp			1	60	FT Hourly	40.00						40.00
PCLI-Corp			1	60	FT Hourly	40.00	0.90					40.90
PCLI-Corp			1	60	FT Hourly	35.70		4.30				40.00
PCLI-Corp			1	60	FT Hourly	34.45		5.55				40.00
PCLI-Corp			1	60	FT Hourly	39.20						39.20
PCLI-Corp			1	60	FT Hourly	36.45						36.45
PCLI-Corp			1	60	FT Hourly	40.00	0.10					40.10
PCLI-Corp			1	60	FT Hourly	40.00						40.00
PCLI-Corp			1	60	FT Hourly	39.35		0.65				40.00
PCLI-Corp			1	60	FT Hourly	36.20		3.80				40.00
PCLI-Corp			1	60	FT Hourly	36.75		3.25				40.00
PCLI-Corp			1	60	FT Hourly	30.95		9.05				40.00
PCLI-Corp			1	60	FT Hourly	31.85		8.15				40.00
PCLI-Corp			1	60	FT Hourly	40.00						40.00
PCLI-Corp			1	60	FT Hourly	40.00	0.05					40.05
PCLI-Corp			1	60	FT Hourly	39.90						39.90
PCLI-Corp			1	60	FT Hourly	40.00	0.05					40.05
PCLI-Corp			1	60	FT Hourly	37.55						37.55
PCLI-Corp			1	60	FT Hourly	40.00						40.00
PCLI-Corp			1	60	Hourly 2/3	20.10						20.10
PCLI-Corp			1	60	Hourly 2/3	25.15						25.15
PCLI-Corp			1	60	Hourly PT	23.00						23.00
PCLI-Corp			1	60	Hourly 3/4	22.30		7.70				30.00
PCLI-Corp			1	66	FT Hourly	40.00	0.40					40.40
PCLI-Corp			1	66	FT Hourly	40.00						40.00
PCLI-Corp			1	66	FT Hourly	40.00						40.00
PCLI-Corp			1	66	FT Hourly	25.40		14.60				40.00
PCLI-Corp			1	66	Hourly 3/4	34.25		5.00				39.25
PCLI-Corp			1	67	Hourly 2/3	23.15		5.00				28.15
PCLI-Corp			10	30	FT Hourly	28.10		16.90				45.00
PCLI-Corp			10	32	FT Hourly	34.75		5.25				40.00
PCLI-Corp			10	32	FT Hourly	37.50		2.50				40.00
PCLI-Corp			10	32	FT Hourly	39.90						39.90
PCLI-Corp			10	32	FT Hourly	40.00						40.00
PCLI-Corp			10	32	FT Hourly	34.75		5.25				40.00
PCLI-Corp			10	32	FT Hourly	40.00	0.05					40.05
PCLI-Corp			10	32	Hourly 2/3	31.20						31.20
PCLI-Corp			10	32	Hourly 2/3	32.75						32.75
PCLI-Corp			10	32	Hourly 2/3	31.50						31.50
PCLI-Corp			10	32	Hourly PT	17.20						17.20
PCLI-Corp			10	32	Hourly PT	22.60						22.60
PCLI-Corp			10	32	Hourly 3/4	33.15						33.15
PCLI-Corp			10	32	Hourly 3/4	22.40		7.60				30.00
PCLI-Corp			10	34	FT Hourly	40.00	0.90					40.90
PCLI-Corp			10	34	FT Hourly	40.00	0.40					40.40
PCLI-Corp			10	34	Hourly 2/3	25.65						25.65
PCLI-Corp			10	34	Hourly 2/3	30.75						30.75
PCLI-Corp			10	34	Hourly 2/3	23.20						23.20
PCLI-Corp			10	34	Hourly 2/3	27.65						27.65
PCLI-Corp			10	34	Hourly 2/3	30.95						30.95
PCLI-Corp			10	34	Hourly 2/3	32.05						32.05
PCLI-Corp			10	34	Hourly PT	8.05						8.05
PCLI-Corp			10	34	Hourly PT	20.20						20.20
PCLI-Corp			10	34	Hourly 3/4	25.20		8.00				33.20
PCLI-Corp			10	34	Hourly 3/4	37.60						37.60
PCLI-Corp			10	34	Hourly 3/4	33.00						33.00
PCLI-Corp			10	34	Hourly 3/4	36.10						36.10
PCLI-Corp			10	34	Hourly 3/4	35.35						35.35
PCLI-Corp			12	32	FT Hourly	40.00	0.20					40.20
PCLI-Corp			12	32	FT Hourly	39.55		0.45				40.00
PCLI-Corp			12	32	FT Hourly	40.00	1.60					41.60
PCLI-Corp			12	32	Hourly 2/3	25.05						25.05
PCLI-Corp			12	32	Hourly 2/3	28.90						28.90
PCLI-Corp			12	32	Hourly 3/4	35.05						35.05
PCLI-Corp			12	32	Hourly 3/4	32.50						32.50
PCLI-Corp			12	32	Hourly 3/4	34.35						34.35
PCLI-Corp			12	34	FT Hourly
PCLI-Corp			12	34	FT Hourly	38.10		1.90				40.00
PCLI-Corp			12	34	FT Hourly	40.00	0.15					40.15
PCLI-Corp			12	34	FT Hourly	40.00	0.30					40.30
PCLI-Corp			12	34	FT Hourly	40.00	0.85					40.85
PCLI-Corp			12	34	Hourly 2/3	27.25						27.25
PCLI-Corp			12	34	Hourly 2/3	28.05						28.05
PCLI-Corp			12	34	Hourly 2/3	18.85		5.15				24.00
PCLI-Corp			12	34	Hourly 2/3	25.00						25.00
PCLI-Corp			12	34	Hourly PT	13.95						13.95
PCLI-Corp			12	34	Hourly PT	23.35						23.35
PCLI-Corp			12	34	Hourly 3/4	30.30						30.30
PCLI-Corp			12	34	Hourly 3/4	33.90						33.90
PCLI-Corp			12	38	Hourly 2/3	28.20						28.20
PCLI-Corp			12	38	Hourly 2/3	28.60						28.60
PCLI-Corp			12	38	Hourly 3/4	10.75		19.25				30.00
PCLI-Corp			12	38	Hourly 3/4	38.10						38.10
PCLI-Corp			14	32	FT Hourly	16.65						16.65
PCLI-Corp			14	32	Hourly 2/3	24.95						24.95
PCLI-Corp			14	32	Hourly 2/3	26.75						26.75
PCLI-Corp			14	32	Hourly 2/3	37.95						37.95
PCLI-Corp			14	32	Hourly 3/4	35.95						35.95
PCLI-Corp			14	32	Hourly 3/4	23.10						23.10
PCLI-Corp			14	34	FT Hourly	39.25						39.25
PCLI-Corp			14	34	FT Hourly	39.95						39.95
PCLI-Corp			14	34	FT Hourly	40.00						40.00
PCLI-Corp			14	34	Hourly 2/3	23.20						23.20
PCLI-Corp			14	34	Hourly PT	8.55						8.55
PCLI-Corp			14	34	Hourly 3/4	28.30						28.30
PCLI-Corp			14	34	Hourly 3/4	34.75						34.75
PCLI-Corp			14	38	FT Hourly	39.35						39.35
PCLI-Corp			14	38	Hourly 2/3	28.25						28.25
PCLI-Corp			14	38	Hourly 3/4	35.70						35.70
PCLI-Corp			14	38	Hourly 3/4	40.00	1.65					41.65
PCLI-Corp			16	32	FT Hourly	39.20		0.80				40.00
PCLI-Corp			16	32	Hourly 2/3	27.30						27.30
PCLI-Corp			16	32	Hourly PT	13.10						13.10
PCLI-Corp			16	32	Hourly 3/4	30.00						30.00
PCLI-Corp			16	32	Hourly 3/4	32.95		4.00				36.95
PCLI-Corp			16	34	FT Hourly	39.35		0.65				40.00
PCLI-Corp			16	34	FT Hourly	39.95						39.95
PCLI-Corp			16	34	FT Hourly	38.45		1.55				40.00
PCLI-Corp			16	34	Hourly PT	13.60						13.60
PCLI-Corp			16	34	Hourly 3/4	33.45						33.45
PCLI-Corp			16	34	Hourly 3/4	31.50						31.50
PCLI-Corp			16	38	Hourly PT
PCLI-Corp			16	38	Hourly PT	21.75						21.75
PCLI-Corp			18	32	FT Hourly	40.00						40.00
PCLI-Corp			18	32	Hourly PT					20.85		20.85
PCLI-Corp			18	32	Hourly 3/4	24.25		5.75				30.00
PCLI-Corp			18	34	Hourly 2/3	21.45						21.45
PCLI-Corp			18	34	Hourly 3/4	27.25		5.00				32.25
PCLI-Corp			18	34	Hourly 3/4	11.80						11.80
PCLI-Corp			18	38	Hourly PT	9.00				9.15		18.15
PCLI-Corp			18	38	Hourly 3/4	31.60						31.60
PCLI-Corp			18	38	Hourly 3/4	28.60						28.60
PCLI-Corp			19	32	FT Hourly	40.00	0.30					40.30
PCLI-Corp			19	32	FT Hourly	39.65		0.35				40.00
PCLI-Corp			19	32	FT Hourly	38.05		1.95				40.00
PCLI-Corp			19	32	Hourly 3/4	34.60						34.60
PCLI-Corp			19	34	FT Hourly	40.00	0.10					40.10
PCLI-Corp			19	34	FT Hourly	39.15		0.85				40.00
PCLI-Corp			19	34	FT Hourly	9.00		31.00				40.00
PCLI-Corp			19	34	FT Hourly	40.00						40.00
PCLI-Corp			19	38	FT Hourly	40.00	0.80					40.80
PCLI-Corp			19	38	Hourly 3/4	31.60						31.60
PCLI-Corp			19	38	Hourly 3/4	31.55						31.55
PCLI-Corp			20	32	FT Hourly	40.00	2.95					42.95
PCLI-Corp			20	32	FT Hourly	40.00	0.05					40.05
PCLI-Corp			20	32	FT Hourly	40.00	0.75					40.75
PCLI-Corp			20	32	FT Hourly	34.90						34.90
PCLI-Corp			20	32	FT Hourly	40.00						40.00
PCLI-Corp			20	32	FT Hourly	38.10		1.90				40.00
PCLI-Corp			20	32	FT Hourly	40.00	0.35					40.35
PCLI-Corp			20	32	FT Hourly	39.00						39.00
PCLI-Corp			20	32	Hourly 3/4	37.55						37.55
PCLI-Corp			20	32	Hourly 3/4	38.90						38.90
PCLI-Corp			20	32	Hourly 3/4	36.35						36.35
PCLI-Corp			20	32	Hourly 3/4	38.40						38.40
PCLI-Corp			20	32	Hourly 3/4	38.45						38.45
PCLI-Corp			20	32	Hourly 3/4	36.90						36.90
PCLI-Corp			20	32	Hourly 3/4	24.80						24.80
PCLI-Corp			20	32	Hourly 3/4	30.65						30.65
PCLI-Corp			20	34	FT Hourly	34.90						34.90
PCLI-Corp			20	34	FT Hourly	39.55						39.55
PCLI-Corp			20	34	FT Hourly	35.75						35.75
PCLI-Corp			20	34	Hourly 2/3	25.80						25.80
PCLI-Corp			20	34	Hourly 2/3	33.20						33.20
PCLI-Corp			20	34	Hourly PT
PCLI-Corp			20	34	Hourly 3/4	36.95						36.95
PCLI-Corp			20	34	Hourly 3/4	38.05						38.05
PCLI-Corp			20	34	Hourly 3/4	38.55						38.55
PCLI-Corp			20	34	Hourly 3/4	29.05		5.00				34.05
PCLI-Corp			20	34	Hourly 3/4	35.05						35.05
PCLI-Corp			20	34	Hourly 3/4	24.60						24.60
PCLI-Corp			20	34	Hourly 3/4	35.25						35.25
PCLI-Corp			20	34	Hourly 3/4	35.85						35.85
PCLI-Corp			20	34	Hourly 3/4
PCLI-Corp			20	38	FT Hourly	40.00	2.05					42.05
PCLI-Corp			20	38	Hourly 2/3	32.15						32.15
PCLI-Corp			20	38	Hourly 2/3	20.55						20.55
PCLI-Corp			20	38	Hourly PT	28.10						28.10
PCLI-Corp			20	38	Hourly PT	21.90						21.90
PCLI-Corp			20	38	Hourly PT	12.15						12.15
PCLI-Corp			20	38	Hourly PT	15.35						15.35
PCLI-Corp			20	38	Hourly PT	6.50						6.50
PCLI-Corp			20	38	Hourly PT	11.85						11.85
PCLI-Corp			20	38	Hourly PT	8.50						8.50
PCLI-Corp			20	38	Hourly 3/4	37.20						37.20
PCLI-Corp			20	38	Hourly 3/4	37.70						37.70
PCLI-Corp			20	38	Hourly 3/4	17.00		18.00				35.00
PCLI-Corp			20	38	Hourly 3/4
PCLI-Corp			20	38	Hourly 3/4	35.55						35.55
PCLI-Corp			20	38	Hourly 3/4	36.45						36.45
PCLI-Corp			20	38	Hourly 3/4	30.65						30.65
PCLI-Corp			20	38	Hourly 3/4	40.00	0.15					40.15
PCLI-Corp			20	38	Hourly 3/4	37.00						37.00
PCLI-Corp			22	32	FT Hourly	39.95						39.95
PCLI-Corp			22	32	FT Hourly	38.65						38.65
PCLI-Corp			22	32	Hourly PT	21.20						21.20
PCLI-Corp			22	32	Hourly PT	10.50						10.50
PCLI-Corp			22	32	Hourly 3/4	33.10						33.10
PCLI-Corp			22	34	FT Hourly	35.15						35.15
PCLI-Corp			22	34	FT Hourly	35.00						35.00
PCLI-Corp			22	34	Hourly 3/4	26.40		3.60				30.00
PCLI-Corp			22	38	Hourly PT	12.35						12.35
PCLI-Corp			25	32	FT Hourly	36.05		3.95				40.00
PCLI-Corp			25	32	Hourly PT	20.30						20.30
PCLI-Corp			25	32	Hourly PT	23.70						23.70
PCLI-Corp			25	34	Hourly 2/3	28.25						28.25
PCLI-Corp			25	34	Hourly PT	24.25						24.25
PCLI-Corp			25	34	Hourly PT	7.95						7.95
PCLI-Corp			25	38	Hourly PT	9.05						9.05
PCLI-Corp			25	38	Hourly PT	34.55						34.55
PCLI-Corp			29	32	FT Hourly	38.05		1.95				40.00
PCLI-Corp			29	32	FT Hourly	38.60		1.40				40.00
PCLI-Corp			29	32	FT Hourly	5.85		34.15				40.00
PCLI-Corp			29	32	Hourly 2/3	29.00						29.00
PCLI-Corp			29	32	Hourly 3/4	29.30						29.30
PCLI-Corp			29	32	Hourly 3/4	22.25		8.00				30.25
PCLI-Corp			29	34	FT Hourly	40.00						40.00
PCLI-Corp			29	34	FT Hourly	38.60		0.40	1.00			40.00
PCLI-Corp			29	34	FT Hourly	40.00						40.00
PCLI-Corp			29	34	Hourly 2/3
PCLI-Corp			29	34	Hourly 2/3	30.95						30.95
PCLI-Corp			29	34	Hourly 2/3	24.75						24.75
PCLI-Corp			29	34	Hourly PT	19.40						19.40
PCLI-Corp			29	38	FT Hourly	28.35						28.35
PCLI-Corp			29	38	Hourly 2/3	27.10						27.10
PCLI-Corp			29	38	Hourly PT	8.75						8.75
PCLI-Corp			29	38	Hourly PT	19.85						19.85
PCLI-Corp			29	38	Hourly PT	14.20						14.20
PCLI-Corp			29	38	Hourly PT	15.15						15.15
PCLI-Corp			29	38	Hourly PT	14.05						14.05
PCLI-Corp			29	38	Hourly PT	19.00						19.00
PCLI-Corp			30	32	FT Hourly	40.00	0.20					40.20
PCLI-Corp			30	32	FT Hourly	27.35		12.65				40.00
PCLI-Corp			30	32	FT Hourly	40.00	1.00					41.00
PCLI-Corp			30	32	FT Hourly	40.00	1.15					41.15
PCLI-Corp			30	32	Hourly 2/3	18.70		5.30				24.00
PCLI-Corp			30	32	Hourly 2/3	13.10		4.40				17.50
PCLI-Corp			30	32	Hourly 2/3	28.45						28.45
PCLI-Corp			30	32	Hourly PT	40.00	0.85					40.85
PCLI-Corp			30	34	FT Hourly	40.00	0.20					40.20
PCLI-Corp			30	34	FT Hourly	39.60		0.40				40.00
PCLI-Corp			30	34	FT Hourly	40.00	0.30					40.30
PCLI-Corp			30	34	FT Hourly	39.95						39.95
PCLI-Corp			30	34	FT Hourly	38.90		1.10				40.00
PCLI-Corp			30	34	FT Hourly	38.70		1.30				40.00
PCLI-Corp			30	34	FT Hourly	40.00	0.15					40.15
PCLI-Corp			30	34	FT Hourly	38.50		1.50				40.00
PCLI-Corp			30	38	FT Hourly	39.60		0.40				40.00
PCLI-Corp			30	38	Hourly 2/3	29.35						29.35
PCLI-Corp			30	38	Hourly 2/3	34.30						34.30
PCLI-Corp			30	38	Hourly 3/4	34.65						34.65
PCLI-Corp			35	32	Hourly 2/3	32.95						32.95
PCLI-Corp			35	32	Hourly 2/3	33.55						33.55
PCLI-Corp			35	32	Hourly PT	23.40						23.40
PCLI-Corp			35	32	Hourly PT	23.45						23.45
PCLI-Corp			35	34	Hourly 2/3	27.10						27.10
PCLI-Corp			35	34	Hourly PT	26.15						26.15
PCLI-Corp			35	34	Hourly PT	22.95						22.95
PCLI-Corp			35	38	Hourly 3/4	35.80						35.80
PCLI-Corp			40	32	FT Hourly	38.60						38.60
PCLI-Corp			40	32	Hourly 2/3			24.00				24.00
PCLI-Corp			40	32	Hourly PT	27.85						27.85
PCLI-Corp			40	32	Hourly PT	27.80						27.80
PCLI-Corp			40	32	Hourly PT	30.40						30.40
PCLI-Corp			40	32	Hourly 3/4	35.95						35.95
PCLI-Corp			40	34	FT Hourly	38.70						38.70
PCLI-Corp			40	34	Hourly 2/3	15.80		9.00				24.80
PCLI-Corp			40	34	Hourly PT	21.80						21.80
PCLI-Corp			40	34	Hourly 3/4	38.00						38.00
PCLI-Corp			40	34	Hourly 3/4	37.15						37.15
PCLI-Corp			40	38	Hourly 2/3	30.35						30.35
PCLI-Corp			40	38	Hourly PT	18.60						18.60
PCLI-Corp			40	38	Hourly PT	30.60						30.60
PCLI-Corp			40	38	Hourly PT	14.90						14.90
PCLI-Corp			40	38	Hourly PT	14.60						14.60
PCLI-Corp			42	32	FT Hourly	31.05						31.05
PCLI-Corp			42	32	FT Hourly	35.95						35.95
PCLI-Corp			42	32	FT Hourly	35.15						35.15
PCLI-Corp			42	32	Hourly 2/3	22.70						22.70
PCLI-Corp			42	34	FT Hourly	37.80						37.80
PCLI-Corp			42	34	Hourly PT
PCLI-Corp			42	34	Hourly 3/4	32.65						32.65
PCLI-Corp			42	34	Hourly 3/4	33.90						33.90
PCLI-Corp			42	34	Hourly 3/4	19.05		11.00				30.05
PCLI-Corp			42	34	Hourly 3/4	25.45		4.55				30.00
PCLI-Corp			42	38	Hourly 2/3	23.80						23.80
PCLI-Corp			42	38	Hourly PT	6.70						6.70
PCLI-Corp			42	38	Hourly PT	7.40						7.40
PCLI-Corp			42	38	Hourly PT	7.80						7.80
PCLI-Corp			42	38	Hourly PT	4.20						4.20
PCLI-Corp			47	32	Hourly 2/3	27.40						27.40
PCLI-Corp			47	32	Hourly 3/4	34.70						34.70
PCLI-Corp			47	34	Hourly 2/3	26.75						26.75
PCLI-Corp			47	34	Hourly 2/3	25.40						25.40
PCLI-Corp			47	38	Hourly PT	7.20						7.20
PCLI-Corp			47	38	Hourly PT	7.35						7.35
PCLI-Corp			47	38	Hourly PT	10.70						10.70
PCLI-Corp			47	38	Hourly PT	6.90						6.90
PCLI-Corp			47	38	Hourly PT
PCLI-Corp			47	38	Hourly PT	11.10						11.10
PCLI-Corp			47	38	Hourly PT
PCLI-Corp			59	32	Alaska	35.45	0.40	1.55				37.40
PCLI-Corp			59	32	Alaska	35.40	0.15	1.60				37.15
PCLI-Corp			59	32	Alaska	36.00	0.10	0.10				36.20
PCLI-Corp			59	34	Alaska	35.80	0.05	0.20				36.05
PCLI-Corp			59	34	Alaska	36.95	0.15	0.10				37.20
PCLI-Corp			59	34	Alaska	36.85	0.20	0.15				37.20
PCLI-Corp			59	34	Alaska	36.90	0.05	0.15				37.10
PCLI-Corp			59	34	Alaska 3/4	32.60	2.25					34.85
PCLI-Corp			59	38	Alaska 2/3	18.30		2.70				21.00
PCLI-Corp			59	38	Alaska PT
PCLI-Corp			59	38	Alaska PT
PCLI-Corp			59	38	Alaska PT
PCLI-Corp			59	38	Alaska PT
PCLI-Corp			59	38	Alaska PT	2.35						2.35
PCLI-Corp			59	38	Alaska PT
PCLI-Corp			59	38	Alaska PT
PCLI-Corp			59	48	Alaska PT
PCLI-Corp			60	32	FT Hourly	32.05						32.05
PCLI-Corp			60	32	FT Hourly	40.00	1.95					41.95
PCLI-Corp			60	32	Hourly 2/3	22.70						22.70
PCLI-Corp			60	32	Hourly 3/4	25.70		8.30				34.00
PCLI-Corp			60	34	Hourly 2/3	28.90						28.90
PCLI-Corp			60	34	Hourly 2/3
PCLI-Corp			60	34	Hourly PT	7.65						7.65
PCLI-Corp			60	34	Hourly 3/4	30.65						30.65
PCLI-Corp			60	38	Hourly PT (Albuq)
PCLI-Corp			60	38	Hourly PT (Albuq)	1.80						1.80
PCLI-Corp			60	38	Hourly PT (Albuq)
PCLI-Corp			60	38	Hourly PT (Albuq)
PCLI-Corp			60	38	Hourly PT (Albuq)	10.60						10.60
PCLI-Corp			60	38	Hourly PT (Albuq)
PCLI-Corp			60	38	Hourly PT (Albuq)
PCLI-Corp			60	38	Hourly PT (Albuq)
Transportation			10	30	Hourly PT	10.75						10.75
Transportation			12	30	Hourly 2/3	24.75						24.75
Transportation			14	30	Hourly PT	13.40						13.40
Transportation			16	30	Hourly PT	4.90						4.90
Transportation			18	30	Hourly PT					15.95		15.95
Transportation			18	30	Hourly PT					10.90		10.90
Transportation			19	30	Hourly PT
Transportation			19	30	Hourly PT	13.25						13.25
Transportation			19	30	Hourly PT	16.00						16.00
Transportation			20	30	Hourly 2/3	31.00						31.00
Transportation			20	30	Hourly PT	24.45						24.45
Transportation			22	30	Hourly PT	10.05						10.05
Transportation			22	30	Hourly PT	6.00						6.00
Transportation			25	30	Hourly PT
Transportation			25	30	Hourly PT	11.80						11.80
Transportation			25	30	Hourly PT	20.45						20.45
Transportation			29	30	Hourly 2/3	28.20						28.20
Transportation			29	30	Hourly PT	17.15						17.15
Transportation			30	30	Hourly PT
Transportation			35	30	Hourly PT	4.25						4.25
Transportation			35	30	Hourly PT
Transportation			40	30	Hourly PT	29.40						29.40
Transportation			40	30	Hourly PT	17.15						17.15
Transportation			40	30	Hourly PT	28.80						28.80
Transportation			40	30	Hourly PT
Transportation			42	30	Hourly PT
Transportation			42	30	Hourly PT	5.00						5.00
Transportation			42	30	Hourly PT
Transportation			47	30	Hourly PT
Transportation			47	30	Hourly PT
Transportation			60	30	Hourly PT
Transportation			60	30	Hourly PT	13.60						13.60
Transportation			60	30	Hourly PT
Transportation			60	30	Hourly PT
Transportation			60	30	Hourly PT

</o

>

Macropod · Jan 4, 2018

This is essentially a duplicate of: https://www.mrexcel.com/forum/excel-questions/1037511-validate.html#post4980177

Kindly read Mr Excel's policy in Rule 12 against asking questions about the same topic in multiple threads: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html
Thread closed. You may continue the discussion in your other thread.

color code

kenpcli

Board Regular

Excel Facts

Macropod

Retired Moderator

Similar threads

Forum statistics

Share this page

color code

kenpcli

Board Regular

Excel Facts

Macropod

Retired Moderator

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock