Another comment:

We've seen the formula: Lookup(Prop.State,"CA;FL;IL;VA") for looking up the currently selected state.

Since there is a Prop.State Shape Data field, that in all likelihood is a drop-down list of four states, we can make this more efficient. Our Prop.State row should have formulas something like this:

Prop.State.Type = 1

Prop.State.Format = "CA;FL;IL;VA"

Prop.State.Value = "FL"

Note that .Format already has the list. We can reference that in other formulas, like in the LOOKUP expression:

LOOKUP( Prop.State, Prop.State.Format )

Since we are using the current state to index a color, we can combine the whole thing into one expression:

FillForegnd = INDEX( LOOKUP( Prop.State, Prop.State.Format ), "1;2;3;4" )

This will yield the following:

California is white (1)

Florida is red (2)

Illinois is green (3)

Virginia is blue (4)

I've attached a shape configured this way that y'all can examine and play with (*must be registered to download attachments*)

Cheers,

Chris