I have a .csv table of Pantone names, corresponding HEX values, and RGB values. How can I display a color swatch based on the user selecting one of the Pantone names from a value list?
So basically, I'll have an edit box, table:Pantone_color, that autocompletes based on the value list containing the Pantone color names, and then based on the value they select, it would display an object (with conditional formatting??) set to fill with the HEX or RGB values related to that Pantone name.
Is this possible? Can anyone give me some direction on this? Thanks in advance!
p.s. I've attached my .csv Pantone data.