- Dec 11, 2004
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.