| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
