Dynamic Color Swatches with Data-Merge
Make the Swatches dynamic with Data-Merge so that you can enter a Colorcode in the Excel document and it changes the Swatch with the same name or something like that.

-
Nico commented
Hi is there a way to use web colors in data CSV to auto change bloc or graphic background color using datamerge
-
Colin Flashman commented
@robinochsner - yes it can. Re-read my link and you will see screenshots of this happening.
-
robinochsner commented
Thank you for your feedback, but still it'd be easier if they included a function that could swap out color swatches. Plus can your method also change the color of Objects (Squares and Spheres etc. or even recollored Illustrator-Files)
-
Colin Flashman commented
This is already possible from InDesign, but it does require some setup. See my article at InDesignsecrets: https://indesignsecrets.com/applying-any-cmyk-color-during-a-data-merge.php