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...
Hi Rob, how did you manage to copy the formula and apply it to the other rows without the formula using the original cell.value as the reference?
Sorry, but that was so long ago, I have no idea. It just had something to do with making sure my references were relative.