Forum Discussion
Federica Dametto
Jul 24, 2018Copper Contributor
Icon sets conditional formating block
Hello everyone,
I want to compare the results from one week to the previous one, like in the attached capture.
I have to use the icon sets, but the problem I am facing is that I cannot repeat the formula. When I set the rule, Excel imposes fixed cells, so I am not allowed to covert them in relative reference (aka delete the $).
I need a way to compare each week to the previous one, without recreate the formula for each of them, I want only to copy-paste. Otherwise it becomes too much time consuming.
I hope it is well explained, Thank you for your help :)
Hi Federica,
Icons set works with absolute references, the workaround to make them "relative" is here http://dailydoseofexcel.com/archives/2015/10/09/conditional-formatting-icons-with-relative-references/