Conditional format icons based on unique values

[Mike_T]

I’ve got a map view with 150+ icons over 30 states. Is there any way to conditionally format the icon’s color by state automatically? I mean without having to create 50 format rules? I don’t really care about the colors, can be random or repeating as long as they are different from state to state.

[Koichi_Tsuji]

unfortunately, not at this moment.

You need to assign 50 differnt colors for all the different states in US by creating 50 different format rule at this moment.

[Mike_T]

Thanks for the confirmation even though it’s not what I wanted to hear.

Just thinking out loud here…what about a Switch function to change the color based on the value?..i’m not solid on Switch function so I’m probably way off.

Thanks again!

[Koichi_Tsuji]

For formating rule settings, not able to use expression, so it is not workable.

[Marc_Dillon]

If you kept the color value in the records themselves, you could reduce your format rules down to the same amount as the number of colors. You should only need 5 or so colors to paint the entire US without adjacent states having the same colors.

[Mike_T]

Now you have my attention.

If you kept the color value in the records themselves,

How would I go about doing this?

[Marc_Dillon]

Add a color column to your table.