Forum Discussion

Federica Dametto's avatar
Federica Dametto
Copper Contributor
Jul 24, 2018

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 :)

Resources