Is it possible to copy a conditional format formula as paste value

[Francois via OfficeKB.com]

I have several rows of data with a header row that has a conditional format
applied depending on a row below.

When I copy that header row to another sheet, the conditional formula still
refers to a row which is no longer where it expects it to be. (because I
copied the header row somewhere else).

Is there anyway that I could get the 'result' of the conditional formula and
NOT have the formula itself ?

ie Can I copy a conditional formula as copy paste special value ?

 

[Bob Phillips]

Not really, you paste with format or without, not part of the format.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Francois via OfficeKB.com]

Not really, you paste with format or without, not part of the format.

I have several rows of data with a header row that has a conditional format
applied depending on a row below.

[quoted text clipped - 7 lines]

ie Can I copy a conditional formula as copy paste special value ?

Oh well, back to the drawing board, thanks anyway