Copy Conditional Formatting to Another Sheet

[magmike]

I am using Excel 2007 and have really embraced the new Conditional
Formatting feature. However, is there a way to copy one sheet's
Conditional Formatting over another sheet's that is already in use and
has data?

Thanks in advance,

magmike

 

[GS]

magmike used his keyboard to write :

I am using Excel 2007 and have really embraced the new Conditional
Formatting feature. However, is there a way to copy one sheet's
Conditional Formatting over another sheet's that is already in use and
has data?

Thanks in advance,

magmike

Have you tried FormatPainter?

 

[magmike]

magmike used his keyboard to write :




Have you tried FormatPainter?

--
Garry

Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

Wow - that was awesome. Thanks!

 

[GS]

magmike used his keyboard to write :

Wow - that was awesome. Thanks!

You're welcome!<g>