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'm copying this type of formula to other cells, but still Conditional formatting is not referring to Relative reference . Can anyone help me to copy this type of color format to any number of cells by using format painter or any other.
Make sure there are no anchors ($) in the formula preventing you from copying the format to different cell rows or columns.
