Fill Cell with Color from Shape's color code

**excelnewbie80** · 05-31-2012, 09:32 PM

Hi,

I have a few shapes which is colored based on a color code (number). I want to replicate the color on the cell so the users can choose the colours they want the shape to be.

For example:
Shape 1---red
Shape 2---blue

On the speadsheet, I want to have
Red Cell---color code of red
Blue Cell---color code of blue

For my shapes, I am using this code:
myShape.Fill.ForeColor.SchemeColor = myColorCode

I am unable to replicate the same color on my cell, how can I do that? Thanks in advance.

**excelnewbie80** · 06-02-2012, 01:44 PM

hello, any help on this? I cant solve this

**FDibbins** · 06-02-2012, 05:34 PM

I dont think there is any way to change the color of a cell using a formula, other than doing it through conditional formatting. But CF relies on the value in a cell, and a "shape" in a cell is not a value. If you could add some value under your shape that the CF could work with though........