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.

Try using the macro recorder, this will generate some code that you can
adapt or reuse.

--

Regards,
Nigel
(E-Mail Removed)



"davegb" <(E-Mail Removed)> wrote in message
news:e465c2a5-26b5-42fd-8ad1-(E-Mail Removed)...
>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.

On Mar 26, 11:56*am, "Nigel" <nigel-...@nosupanetspam.com> wrote:
> Try using the macro recorder, this will generate some code that you can
> adapt or reuse.
>
> --
>
> Regards,
> Nigel
> nigelnos...@9sw.co.uk
>
> "davegb" <daveg...@comcast.net> wrote in message
>
> news:e465c2a5-26b5-42fd-8ad1-(E-Mail Removed)...
>
>
>
> >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.- Hide quoted text -
>
> - Show quoted text -

Thanks, Nigel, but I already did that. I can copy the formatting, or
open the dialog box, but I can't figure out how to copy the color
values across that way.