Forum Discussion
Need help with visualizing increasing and decreasing in a row.
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
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.