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