View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Beat
 
Posts: n/a
Default 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?