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...
Roger Dance I spent hours trying to figure this out. I finally came across a video that actually gave me the information I was looking for:
CStendardo I watched that video, thanks. And the one after it on 8 COnditional Formatting Tips and was able to work out the issue . Success.
Best tip from video was to craft the conditional test in an adjacent cell to determine if it evaluates TRUE or not. Then copy that working formula to the window inside Conditional Formatting to enter the formula correctly.
I was able to select a column of number and then enter the conditional formatting function successfully. I then selected the working formatted column's rows and used the PAINTER icon tool to copy that formatting to other columns.
