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