copying table with cond.formating using value and resulting color

I have a complex formula to determine the condition for the conditional
formatting. This is referencing to different tables.
I like now to copy the result (values and shown format; without formulas) to
a new wokbook.
How can I do this?

How about just

Copy|paste

followed by
selecting the pasted range
edit|copy
edit|paste special|values


Beat wrote:
>
> I have a complex formula to determine the condition for the conditional
> formatting. This is referencing to different tables.
> I like now to copy the result (values and shown format; without formulas) to
> a new wokbook.
> How can I do this?

--

Dave Peterson

You may have to reverse the procedure. Paste values first, then formats.

Dave Peterson wrote:
>
> How about just
>
> Copy|paste
>
> followed by
> selecting the pasted range
> edit|copy
> edit|paste special|values
>
> Beat wrote:
> >
> > I have a complex formula to determine the condition for the conditional
> > formatting. This is referencing to different tables.
> > I like now to copy the result (values and shown format; without formulas) to
> > a new wokbook.
> > How can I do this?
>
> --
>
> Dave Peterson

--

Dave Peterson

Thanks for trying. Your procedure only works for standard formats, not for my
conditional formatting, when the condition is referenzing outside the copied
table ....

my condition-formula looks like:
=INDIRECT(ADDRESS($A6;COLUMN();1;FALSE;"old");FALSE)

unfortunaltely with your procedure you dont erase (fix) the conditional
formatting.

"Dave Peterson" wrote:

> You may have to reverse the procedure. Paste values first, then formats.
>
> Dave Peterson wrote:
> >
> > How about just
> >
> > Copy|paste
> >
> > followed by
> > selecting the pasted range
> > edit|copy
> > edit|paste special|values
> >
> > Beat wrote:
> > >
> > > I have a complex formula to determine the condition for the conditional
> > > formatting. This is referencing to different tables.
> > > I like now to copy the result (values and shown format; without formulas) to
> > > a new wokbook.
> > > How can I do this?
> >
> > --
> >
> > Dave Peterson
>
> --
>
> Dave Peterson
>