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 ?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200609/1