Conditional Formatting copy as like formulas paste special

Hello Friends

We are copying the output (May be text or numbers) from a formulas to text / numbers by using COpy > Psate Special > Values option.

So the associativity is removed between the formulas and the output, in future even if we removed the inputs then the copied and pasted special as values will get the exact output.

As like i need to use the same concept for conditional formatting. For certain conditions i text colored and text color filled the entire rows in a excel sheet, now my intension is i want to copy the row text to new sheet / file with removed conditional formatting but retaining the formats done by conditional formatting.

Is there any way to do this ?

thanks in advance

thilag

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.