Conditional Formatting a base value plus a selection.

[DaxnDangerous]

I regularly find solutions to my novice coding on this forum, but have been unable to figure a solution for this issue.

I would like to conditionally format the table on the right to do one of the following options based on the state that is selected from the map.

Preferred Result: Alabama is highlighted on load (see pic) and when a state is selected from the map, the selected state is also highlighted in the table in a different color.

Second Option: Alabama is highlighted on load (see pic) and when a state is selected from the map, the selected state is also highlighted in the table in the same color.

Third Option: Alabama is highlighted on load (see pic) and when a state is selected from the map, the selected state is highlighted in the table instead of Alabama.

 

  

[lbendlin]

You get the third option for free if you allow users to store filter choices across sessions.