Forum Discussion
Deleted
May 08, 2017Conditional Format copying with rules
I have a spreadsheet that as you input dates in that row of various visits the entire row will change color to the cooresponding color assigned for the entire row. I have the row working properly ut...
SergeiBaklan
May 08, 2017Diamond Contributor
Hi Tony,
Format Painter shall work if you use relative referencies on columns in your rules formula, not absolute one, for example
=($A1>5) but not =($A$1>5)