The Prompt Text
--------
Highlight all "G" footers located on sheets S1.1.1 and S1.1.2 red.
Highlight all "H" footers located on sheets S1.1.1 and S1.1.2 green.
Highlight all "E" footers located on sheets S1.1.1 and S1.1.2 blue.
Create a report of the footers highlighted with data showing how many of each type.
Expected Output
--------
Output Format: Table