Forum Discussion
Solved
Trending a row using trend arrows - conditional formatting
Hi all, Long story short: I'm using conditional formatting "format cells based on their values" with the arrows for monitoring the trend of some indicators. Each day the indicators produce a percent...
Unfortunately, it is not possible to use relative references in a conditional formatting rule of type Icon Sets.
As an alternative, create 3 rules that set the fill color:
Here are all three rules:
Result:
Unfortunately, it is not possible to use relative references in a conditional formatting rule of type Icon Sets.
As an alternative, create 3 rules that set the fill color:
Here are all three rules:
Result:
It seems a valid alternative
Thanks
Luca
Thanks
Luca