Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have a column that contains the data and a set of rules for the conditional format of the cells.

i.e. the conditional format changes the background colour of some cells if they are negative.

I would like to copy this column with the resulting format and paste it in another place "by value", in our example I want as result a column without any more conditional formatting rules for the cells but only with the computed colour for the background (with the computed format).

  • If I use paste special with only text and number options checked I lose the background colour.
  • If I use paste special with format option checked I copy even the rules.

Is there any way to do it without a macro? Thanks

share|improve this question

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.