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

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?

--
Garry

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

On Oct 6, 3:37*pm, GS <g...@somewhere.net> wrote:
> 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?
>
> --
> Garry
>
> Free usenet access athttp://www.eternal-september.org
> ClassicVB Users Regroup! comp.lang.basic.visual.misc

Wow - that was awesome. Thanks!

magmike used his keyboard to write :
> On Oct 6, 3:37*pm, GS <g...@somewhere.net> wrote:
>> 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?
>>
>> --
>> Garry
>>
>> Free usenet access athttp://www.eternal-september.org
>> ClassicVB Users Regroup! comp.lang.basic.visual.misc
>
> Wow - that was awesome. Thanks!

You're welcome!<g>

--
Garry

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