Linking Data to Visio Shapes 

It is in the article....

Do you mean that you have Red as a text value in a cell? Or as RGB(255,0,0) ? Or as 2? "Red" will not work, but these other two could. However, you cannot go direct to the FillForegnd using Data Visualizer and need to via a Shape Data row. Have you reviewed my posts : bvisual.net/?s=DATA+Visualizer ?

Or maybe bvisual.net/2022/04/18/update-any-visio-shapesheet-cell-with-external-data/

Yes there is, but you need add the ShapeSheet formulas such as =Sheet.123!Prop.MyData ... I suspect that you are looking for a less geeky way though?