Hi there,
I have created a table that includes some conditional formatting. Some of the formulas lock the collum ($B) so that all collumns in that table are effected.
However, I would like to be able to copy the tables (all it's collumns) and the respective conditional formats. If my CF are locked to collumn B in the first table, I would like the copied table to be fixed to collumn F, and so on and so on.
I appreciate that I have $locked$ them but wonder if I can duplicate the selected collumns and move the conditional formatting with it.
If you see cell C11, for example, you will see the 3 formulas in CF. In G11, they are still locked to $B, whereas I want $F.
Thanks in advance,
Danny
Bookmarks