Trending a row using trend arrows - conditional formatting

Question

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 percentage that has to be compared with the day before.&nbsp;&nbsp;At the moment I'm applying the conditional formatting to each single cell in the row to be compared with the value of the previous cell.&nbsp;&nbsp;&nbsp;I wonder if there is any formula that I can input in the conditional formatting values that I can apply to the entire trow (instead of doing it with every single cell) which compares each cell of the same row, with the adjacent ones.&nbsp;&nbsp;ThanksLuca&nbsp;&nbsp;

hansvogelaar · Accepted Answer

uhwdelirium&nbsp;
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:

&nbsp;

Forum Discussion

Trending a row using trend arrows - conditional formatting

2 Replies

Resources