Autoshape color to match fill color of cell

[djl0525]

Keyboard!CB8 has conditional formatting that changes it's color. On sheet Lookup Chords, I have an AutoShape named KeyC1. Can VB format the AutoShape the same color as the cell? I'm okay with running the code whenever the cell color changes.

--DJ

 

[djl0525]

Or, is it possible to put Conditional Formatting on an AutoShape? Like, make the shape KeyC1 black if CB8 = 2.

--DJ

 

[djl0525]

Nevermind. I found code on the internet I can use with a workaround.

--DJ