Thanks in advance for taking this question.
Basically, I have several different market areas which I would like to color code by (placing them into regions). See the screenshot attached.
I want to group these individual markets into say 4 Groups: East, West, North, South and color-code them.
For example, I would like to put NY Metro and Northeast into the "East" Group, and make it Red,
San Jose and So. Co into the "West" Group and make it Blue,
Florida and Carolinas into the "South" Group and make it Pink
and so on
Can someone please let me know what I have to do to
a) Create these groups
b) What the expression needs to be to color code these
c) Where I write the expression/and create these groups
I REALLY appreciate it!