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...
It shall be relative reference for the row, e.g. Cell Value = $A1. Otherwise you always compare with the value in A1.
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
