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 onlytext
andnumber
options checked I lose the background colour. - If I use
paste special
withformat
option checked I copy even the rules.
Is there any way to do it without a macro? Thanks