I have a continental US map. On my spreadsheet, each state is followed by a value which is displayed when you hover over the state. No problem there.
I have a complicated calculation that I do in the spreadsheet for each state. I have the calc result in assigning either a 0, 1, 2, or 3 to each state. I want to alert white on 0, green on 1, yellow on 2, and red on 3. But I can't figure out how to have the alerts reference those data points.
Here's how it's laid out:
Row 1, Columns 1 - 52 are the state names
Row 2, Columns 1-52 are the values I want displayed (this is working fine)
Row 1, Columns 53 - 105 are the state names again
Row 2, Columns 53 - 105 are the values 0, 1, 2, or 3; if 0 then I want the state to appear white, if 1 then I want the state to appear green, if 2 then I want the state to appear yellow, if 3 then I want the state to appear red.
Is this possible?
Thanks in advance!