Forum Discussion
Copying Conditional formatting with relative cell referencces in the formula desn't work
I have a cell H19 conditionally formatted "Format values where this formula is true" with: ="h19>$C$19" and then the colour green When I copying the cell with Format Painter to cells H20 to H90, the...
Dragging the cell, pasting normally OR pasting the format in multiple cells in one paste operation won't work. It will keep the formula in conditional formatting referencing to copied cell and will make it applicable to the range of pasted cells.
I found a simple workaround.
Copy the cell with conditional formatting and paste it into the cell below it. Then select these two cells, copy them and paste them to the next two cells below; and then select these four cells and copy them to the next 4 cells below. Next, you will have 8 cells to copy and paste, next you will have 16 cells to copy and paste; every time doubling the cells available to be copied.
With this workaround, the conditional formatting formula will refer to the cell reference where you have pasted it .
I found a simple workaround.
Copy the cell with conditional formatting and paste it into the cell below it. Then select these two cells, copy them and paste them to the next two cells below; and then select these four cells and copy them to the next 4 cells below. Next, you will have 8 cells to copy and paste, next you will have 16 cells to copy and paste; every time doubling the cells available to be copied.
With this workaround, the conditional formatting formula will refer to the cell reference where you have pasted it .