Thread: Object color based on cell color

I am trying to find a method that will allow an object color to be directly associated with the fill color used in a cell. For example I would like object FHCSCali to equal the fill color dynamically for cell I32. Any help is appriciatedScreenHunter_01 Feb. 13 08.37.jpg

-Wagz

You would need to convert the colorindex of the cell to rgb and then something on the lines of Me.Shapes("MyShape").ShapeRange.Line.BackColor = xxx check out Chips site for the code to convert colours
http://www.cpearson.com/excel/colors.aspx


Google Me
Find me located here Simon Lloyd and what i'm about Here
The above is NOT a link to a forum so is NOT against Rule 13