this is an old question, but mine is related, so I don´t want to make a new one :-)
The copying is OK. Only with one negative:
In my table, I have CF that marks the whole row based on what is written in the 1. cell (a.k.a. if in A1 is "OK", the whole A row in a table will be marked green)
But if I copy this CF (via format painter) to B1, the CF for B1 applies only for B1, not for the whole B row
- the CF is as formula "=$A8="OK"", applies to "=$A$8:$V$8"
(I cannot change the applies to into "=$A8:$V8", as it always automatically changes to =$A$8:$V$8" :-(
- after copying the format (the CF) to cell A9, the formula changes to "=$A9="OK"", but the applies to changes only to "=$A$9"
Is there a way to copy the CF, so it also copies the "applies to" range (in this case that it will automatically set the applies to in A9 to ""=$A$9:$V$9"?
I have about 400 rows and absolutely no time to do it manually :-(
thanks a lot