Forum Discussion
Copying conditional formatting / Changing absolute to relative
Hello - I am trying to copy a conditional format down through multiple rows but cannot get my conditional formula to change to relative, it keeps reverting back to absolute. Is this something not po...
nancynancy I overlooked the fact that this is in a pivot table. At the top of the C.F. dialog (you posted a screen-shot), don't use the "Selected cells" choice, but select either of the two subsequent options: "All cells showing...". This will cause Excel to automatically expand and contract the conditional format range as your pivot table grows or shrinks.