MS XL2007: Is there an efficient way to embed "color of cell RnCm = color of
cell RnC(m-x)" where c1 rows are manually changed from time to time? So that
a cousin cell a few rows over automatically reflects a hilite/font color
change manually applied to the the corresponding row in the first column?
Data in both columns is text/general. Obviously copy/paste-format would do
it inelegantly, a macro could presumably lookup & apply color somehow (still
a bit clunky), but I seek a formulaic/automatic method.

Schooner