Forum Discussion
Need help with visualizing increasing and decreasing in a row.
Hi,
I'm trying to visualize the changes in each cell in a row.
For example, compare with the qty. of 100 on Dec. 03 and 80 on Dec. 04, I can see the qty. of 20 is decreased. So, I want to visualize a down arrow on cell C2 that the qty. is decreased compared with cell B2. In Cell F2, the qty is increased compared with cell E2, so I want to add an up arrow on cell F2.
I tried using conditional formatting, but it did not work. Maybe I just did not know how to properly use it. Please tell me if there is any way that I can visualize these changes in each cell.
Another variant, with icons within same cells
- apply the rule only to the first cell in the row
- use Formula Type with ">" for green and ">=" for yellow
- add exactly the same formula to both
=OFFSET($B$2,0,COLUMN()-COLUMN($B$2)-1)such formula is since rule accepts only absolute references in formula
- apply the rule to this cell
- double click on Format Painter and apply formatting on another cells in the row
it shall be like this
4 Replies
Another variant, with icons within same cells
- apply the rule only to the first cell in the row
- use Formula Type with ">" for green and ">=" for yellow
- add exactly the same formula to both
=OFFSET($B$2,0,COLUMN()-COLUMN($B$2)-1)such formula is since rule accepts only absolute references in formula
- apply the rule to this cell
- double click on Format Painter and apply formatting on another cells in the row
it shall be like this
Thank you so much for the help.
Do I need to format painting every time when I want to apply this to next cell?
It seems like it won't work if I simply copy and paste or drag and drop.
Yes, here is with Format Painter. And you need to correct OFFSET() formula if cells are on other rows.
