I have a list of the 50 US states plus DC in an Excel document in a named range where the first row is a column heading.

How do I make a four-color map
where each state gets its own color that is different from its neighbors, and
where I can zoom to each state.

TIA,

Far Farley