copying table with cond.formating using value and resulting color

B

Beat

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?
 
D

Dave Peterson

How about just

Copy|paste

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

Beat

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 said:
You may have to reverse the procedure. Paste values first, then formats.
Click to expand...
 
Top