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...
I just figured this out. If you copy the cell with conditional formatting and paste it TO ONE OTHER CELL it retains the conditional formatting and changes it relative to the cell.
If you copy and paste it TO A RANGE of cells, it does NOT change the cell relative to the others.
This means you have to ctrl+C/V a bunch of times to do a range, but it takes less time than going through the conditional formatting section and updating and achieves what you want.
