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...
Thank you for calling out the one subtle difference that allows the format painter to retain relative references!
For those still confused, notice the differences to the rule cell values as shown below:
Original Rules
| Rule (applied in order shown) | Format | Applies to |
| Cell Value = $A$1 | AaBbCcYyZz | =$B$1 |
| Cell Value <> $A$1 | AaBbCcYyZz | =$B$1 |
New Rules
| Rule (applied in order shown) | Format | Applies to |
| Cell Value = $A1 | AaBbCcYyZz | =$B$1 |
| Cell Value <> $A1 | AaBbCcYyZz | =$B$1 |
Changing $A$1 to $A1 allowed the format painter to paste relative values to rest of the cells.
Thanks for you your help SergeiBaklan
