Named Locations

[MrDB4Excel]

Following are two searches I have done to hopefully find an answer to the search questions.
How to set fill color within a named location when an Excel named location is selected & Apply a fill color to an Excel named location when it is selected.
Neither one seemed to give me what I needed to make this happen, so here goes, Xl2bb attached.
The crux of this issue is simply that when I select a cell that has a hyperlink to a set of cells (a named location) on another sheet I want the named location that becomes active per the hyperlink just selected to show a fill color.
Then when I go back to the first sheet that contains the single cells with hyperlinks to named locations then the named location just visited becomes no fill color.
In other words, on the destination sheet (SpaceImageArray) with many named locations, only the one just selected on the source sheet (Space_Images) links to the named location on SpaceImageArray and thus becomes the filled or highlighted color of my choice. Only the cells and has no effect on the image in that location. When I leave that page by picking on an image that links back to cell A1 on the Spave_Images sheet then the previous named location fill becomes no fill.
Finally, these Xl2bb attachments are only a very small indication of how I am using this in a different workbook that contains hundreds of picture images, images of PDFs, and many other associated files that this workbook is a database for, namely visas, passports, and other such relevant data, thus why I created this bogus workbook showing space images. The end result is the same no matter whether it is this space image workbook or my other workbook.

Obviously, the second Xl2bb attachment did not bring with it the inserted images so the attached image will suffice to show you what it really looks like.

Named Locations Fill Color.xlsx
	A	B	C	D	E	F	G	H	I
1	KB Size	File Type	File Name	Folder Locations	Concatenation of Columns "C" & "F"	1	Images
2	55	.jpg	1452110008798.jpg	F:\Jpg\Space\	F:\Jpg\Space\1452110008798.jpg	#1	1:		1: 1452110008798.jpg
3	64	.jpg	1453393562887.jpg	F:\Jpg\Space\	F:\Jpg\Space\1453393562887.jpg	#1	2:		2: 1453393562887.jpg
4	43	.jpg	1453929916073.jpg	F:\Jpg\Space\	F:\Jpg\Space\1453929916073.jpg	#1	3:		3: 1453929916073.jpg
5	51	.jpg	1487863488332.jpg	F:\Jpg\Space\	F:\Jpg\Space\1487863488332.jpg	#1	4:		4: 1487863488332.jpg
6	50	.jpg	1487863512851.jpg	F:\Jpg\Space\	F:\Jpg\Space\1487863512851.jpg	#1	5:		5: 1487863512851.jpg
7	33	.jpg	1487863547878.jpg	F:\Jpg\Space\	F:\Jpg\Space\1487863547878.jpg	#1	6:		6: 1487863547878.jpg
8	78	.jpg	1487863567493.jpg	F:\Jpg\Space\	F:\Jpg\Space\1487863567493.jpg	#1	7:		7: 1487863567493.jpg
9	191	.jpg	462977main_sun_layers_full.jpg	F:\Jpg\Space\	F:\Jpg\Space\462977main_sun_layers_full.jpg	#1	8:		8: 462977main_sun_layers_full.jpg
10	82	.jpg	463940main_atmosphere-layers2_full.jpg	F:\Jpg\Space\	F:\Jpg\Space\463940main_atmosphere-layers2_full.jpg	#1	9:		9: 463940main_atmosphere-layers2_full.jpg
Space_Images

Cell Formulas
Range	Formula
F1	F1	=COUNTA(#REF!)
E2:E10	E2	=CONCATENATE(D2,C2)
F2:F10	F2	=HYPERLINK(E2,"#1")
B2:B10	B2	=RIGHT(C2,4)
I2:I10	I2	=G2&": "&C2

Named Locations Fill Color.xlsx
	A	B	C	D	E	F	G	H	I
1
2		1: 1452110008798.jpg		4: 1487863488332.jpg		7: 1487863567493.jpg		1: 1452110008798.jpg
3								2: 1453393562887.jpg
4								3: 1453929916073.jpg
5								4: 1487863488332.jpg
6								5: 1487863512851.jpg
7								6: 1487863547878.jpg
8								7: 1487863567493.jpg
9								8: 462977main_sun_layers_full.jpg
10								9: 463940main_atmosphere-layers2_full.jpg
11
12
13
14
15
16		2: 1453393562887.jpg		5: 1487863512851.jpg		8: 462977main_sun_layers_full.jpg
17
18
19
20
21
22
23
24
25
26
27
28
29
30		3: 1453929916073.jpg		6: 1487863547878.jpg		9: 463940main_atmosphere-layers2_full.jpg
31
32
33
34
35
36
37
38
39
40
41
42
43
SpaceImageArray

Cell Formulas
Range	Formula
B2	B2	=H2
D2	D2	=H5
F2	F2	=H8
H2:H10	H2	=Space_Images!I2
B16	B16	=H3
D16	D16	=H6
F16	F16	=H9
B30	B30	=H4
D30	D30	=H7
F30	F30	=H10

 

[MrDB4Excel]

I am writing a reply to myself in the hopes of bringing further understanding of what I am trying to accomplish.
If I were to rename this post it would be: Fill Color When Named Range Becomes Active

Following are several searches I have done today in hopes of finding a solution. So far the only solution I found involves VBA and while it seems to work just fine I was hoping for a non-VBA solution.
How to cause all cells that belong to a named range to highlight only when selected
When a named range becomes active how to show this named range with a fill color
How to show the named range with fill color when this named range is active
How to set Fill Color When Named Range Becomes Active
Excel Checkbox: If Checked then Change Cell Color
How to run a VBA code from selecting a single cell

This just seems to be a simple solution involving the use of formulas but I am thinking this is not possible.
I select one cell in the Space_Images Sheet that then jumps to the named range on the SpaceImageArray Sheet indicated in the hyperlink of that one cell but also contains a formula to cause the jumped to named range to set a fill color.
Then when that named range becomes active all cells in that named range changes to the fill color of my choice.
When leaving that named range on the SpaceImageArray Sheet and going back to the source sheet, Space_Images, then that named range on the SpaceImageArray Sheet returns to no fill color.

The VBA code I found does item #s 1 & 2 but does not do item #3, leaving the named range with no fill color but instead leaves the recently acquired named range the color indicated by the code when I navigate away from this destination sheet:

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
Sh.UsedRange.Interior.ColorIndex = 0 'change colorindex to select background color
Target.Interior.ColorIndex = 8 'change colorindex to select active cell color
End Sub