Excel 2003/Windows XP -- tricky situation encountered. I have a complex
sequence of macros that, among other things, uses conditional formatting to
colorize two columns of data (Col F and Col G). That works fine. However,
one of the later steps in the sequence may shuffle columns around based on a
user-defined template. Sometimes this means the data from Cols F/G moves to
Cols X/Y or whatever. But the conditional formatting remains back in Cols
F/G and gets applied to whatever data resides in those columns after the
shuffle, producing nonsense. Does anyone know a way I can let the
conditional formatting do its thing, but then "freeze" the resulting colors
so if the data moves, the colors go with it?