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?

copying table with cond.formating using value and resulting color
 

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

copying table with cond.formating using value and resulting color
 

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

copying table with cond.formating using value and resulting co
 

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");FALS E)

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