I have conditional formatting in cells A1 thru C1. I'd like to have a
macro open the conditional formatting box for A1, let me manually
enter new colors, then close the conditional formatting dialog and
have the code copy the colors for the font and background from A1 to
B1 and C1, leaving the conditions as they are in each individual cell.
I don't have a clue as to how to start getting those values from the
first cell, much less putting them into the conditional formatting for
the other cells without disturbing the formulas. This is part of a
larger macro that creates this spreadsheet. Does anyone know how to go
about this?
Thanks in advance.