Copy conditional format colors to another cell

D

davegb

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.
 
N

Nigel

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

davegb

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

--

Regards,
Nigel
(e-mail address removed)






- 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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top