Analyzing A Range Of Cells, Clear Values Immediately Preceeding and Proceeding A Blank Cell

[Ark68]

I am struggling to find a vba solution for a task I need to do with a range of cells in my worksheet. Part of the problem will be trying to explain.

Consider this sample of data that prior code produces.

wsop 22.0327.xlsm
	H	I	J	K	L	M	N	O	P	Q
15	Vacnacy	Vacnacy	Vacnacy		HPE	HPL			HPL
DISPATCH

My goal is to to eliminate any values in the cells except those immediately preceeding and proceeding an empty unshaded cell.
I think what I am aiming for is this ...

wsop 22.0327.xlsm
	H	I	J	K	L	M	N	O	P
16			Vacnacy		HPE	HPL			HPL
DISPATCH

The values in this range are dynamic, and can be an any combination.

 

[Ark68]

I am still struggling to find a solution for this task. It is the one task that is causing me the greatest delay in the progress of my application. Things have changed a bit, so what was suggested doesn't work for the new structure I have.

Consider the following testing data:
BEFORE

WS 30-May-22.xlsx
	H	I	J	K	L	M	N	O	P	Q
13	CRP	RPE1	RPE1							RPL1
14	CRP	RPE1	RPE1							RPL1
15	CRP	RPE1	RPE1							RPL1
16	CRP	RPE1	RPE1							RPL1
17	CRP	RPL1	RPL1							RPL1
18		RPL1	RPL1
19		RPL1	RPL1
20		RPL1	RPL1
21	CRP	RPE1	RPL1							RPL1
22		RPL1	RPL1
23		RPL1	RPL1
24		RPL1	RPL1	AUTO	AUTO
25	CRP	RPL1	RPL1	RPL1	CUL1					CUL1
26		RPL1	RPL1
27		RPL1	RPL1
28		RPL1	RPL1	RPL1	CUL1
29		RPL1	RPL1	AUTO	AUTO
30		RPL1	RPL1	AUTO	AUTO
31		RPL1	RPL1	AUTO	AUTO
32	NR	RPL1	RPL1							RPL1
33	NR	RPL1	RPL1							RPL1
34	NR	RPL1	RPL1							RPL1
35	NR	RPL1	RPL1							RPL1
36	CRP	RPE1	RPL1							RPL1
37	CRP	RPL1	RPL1							RPL1
38		RPL1	RPL1	AUTO	AUTO
39		RPL1	CUE1							RPL1
40	CRP	RPE1	RPL1	RPL1	CUL1					CUL1
41	CRP	RPE1	RPL1	RPL1	CUL1					CUL1
42		RPL1	RPL1	AUTO	AUTO
43		RPL1	RPL1	AUTO	AUTO
44		RPL1	RPL1	AUTO	AUTO
45		RPL1	RPL1	AUTO	AUTO
RPL

• In this example ... Target cells hold crew value = RPL (all RPL1 cells will remain unshaded with the text white to obscure value or value cleared)
• Any cell to the immediate left (except for column H) and right (except column Q) of a target cell (RPL) will have their value checked. If it is not RPL, the value in the adjacent cell remains, but the cell is shaded grey (rgb 166, 166, 166).
• Any cell adjacent to the target cell that is shaded will remain shaded. Those cells are empty (so would not match the target cell value anyway)
• Cells with the Value "AUTO" will remain and be shaded regardless of where they fall in relation to a target cell.

AFTER

WS 30-May-22.xlsx
	H	I	J	K	L	M	N	O	P	Q
13			RPE1
14			RPE1
15			RPE1
16			RPE1
17	CRP
18
19
20
21		RPE1
22
23
24				AUTO	AUTO
25	CRP				CUL1
26
27
28					CUL1
29				AUTO	AUTO
30				AUTO	AUTO
31				AUTO	AUTO
32	NR
33	NR
34	NR
35	NR
36		RPE1
37	CRP
38				AUTO	AUTO
39			CUE1
40		RPE1			CUL1					CUL1
41		RPE1			CUL1					CUL1
42				AUTO	AUTO
43				AUTO	AUTO
44				AUTO	AUTO
45				AUTO	AUTO
RPL

I will be most grateful to all that help me find a solution to this hurdle.