Thread: Is it possible to copy a conditional format formula as paste value
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
  
Posts: 10,593
Default Is it possible to copy a conditional format formula as paste value
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" <u18959@uwe wrote in message
news:66a99c4f85d54@uwe...
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



Reply With QuoteReply With Quote